SQL Server Query - Multiple Order By column and per Same Grouping -


sample table

enter image description here

i need sort record above remarks in ascending order, , firstdate in descending order, , lastdate in descending order

i query

select * tblrecord  order remarks, firstdate desc, lastdate desc 

and gives me output

enter image description here

it should this:

enter image description here

updated: startdate , enddate refer actual start date , last date operation of tenants, want separate sorting of tenant per remarks, when ceased, sorting should based on firstdate in descending order, when started, should per enddate in descending order.

not sure looking seeing aren't responding moment, have 2 situations in can result looking for, 1 of these deffinitely wrong or both wrong both produce result looking test data provided

situation 1: need order startdate descending when remarks ceased , startdate ascending when remarks started in case code: sqlfiddle

select * mytable order remarks, case when remarks = 'started' startdate end asc, case when remarks ='ceased' startdate end desc, enddate desc 

situation 2: when have remark ceased need order records startdate , when remark started need order enddate, in case query be: sqlfiddle

select * mytable order remarks, case when remarks = 'started' enddate end desc, case when remarks ='ceased' startdate end desc; 

Comments