Preference to a row in Cursor

lanand_hps · New User Joined: 05 Dec 2007 Posts: 82 Location: chennai

Hi,
I've three rows in table as

EmployeeName Coveraege

Name1 Accc.Death
Name1 HMS
Name1 Supp.

Name2 Supp.
Name2 HMS

For all employees, i need to fetch "HMS" coverage first and then all the other coverages.

Pl give me some idea..

Thanks,
Anand

Prajesh_v_p · Active User Joined: 24 May 2006 Posts: 133 Location: India

Try out this query..

select EmployeeName,
Coveraege,
Case Coveraege
when 'HMS'
then 1
else
2
end descrip
from table
order by EmployeeName, descrip

Hope this helps..

Prajesh