sample table

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

it should this:

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
Post a Comment