Wednesday, 25 April 2012

How to order field by its second character?

Hi All,

SELECT first_name, SUBSTR(first_name, 2) as first_name_sub FROM tbl_passport_application ORDER BY first_name_sub DESC;


Cheers!

No comments:

Post a Comment