I have a table employee. The table structure is as follows


empid empname
1 vinay shetty
2 arun kumar
3 prashanth malhotra
4 akshay dubey
5 praveen kini
6 mukund pai


Now i need to write a query by using Criteria such that the result should be in the sorted of last name.(Shetty,Kumar,Malhotra..).

Corresponding SQL query for mysql is as follows :

select SUBSTRING_INDEX(SUBSTRING_INDEX( empname , ' ', 2 ),' ',-1) AS lastname from employee order by lastname desc


Thanks in advance.

-Arun