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