InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 18:04:32 GMT20http://www.sqlservercentral.com/Forums/Topic929050-338-1.aspxThank you very much lowell... :)Fri, 28 May 2010 00:38:02 GMTShekharNaiduhttp://www.sqlservercentral.com/Forums/Topic929050-338-1.aspxanother way without the UNION:[code]select CASE WHEN manager='Y' THEN 1 ELSE 2END as myorderBy,name,salary from sometable ORDER BY myorderBy,salary[/code]Thu, 27 May 2010 09:14:45 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic929050-338-1.aspxhey Lowellthat was awe some... thank u very much.. :)Thu, 27 May 2010 09:03:40 GMTShekharNaiduhttp://www.sqlservercentral.com/Forums/Topic929050-338-1.aspx[code]select 1 as myorderBy,name,salary from sometable where manager='Y'UNION ALLselect 2 as myorderBy,name,salary from sometable where manager='N'ORDER BY myorderBy,salary[/code]Thu, 27 May 2010 09:00:52 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic929050-338-1.aspxHi allone more tricky query I have encountered..(@ an interview)..we have employee table with manager name and salary..now the question is..write a query to display employee records order by salaryand the manager record should be the first record in the result...Thu, 27 May 2010 08:58:42 GMTShekharNaidu