Order by results by different columns

[javakid]

Hi all
I have results with different columns and i want to order the data according to different columns under different conditions.

I have four columns: isflagged(T/F), FlaggedAt(Time) , createdAt(time) ,updatedAt(time ).

For the rows which have isFlagged as T, i want them at top in result, order by FlaggedAt descending.
and for the rows which have isFlagged as F , want them to be order by createdAt when created is not null otherwise by updatedAt.


How can I acheieve this,

Thanks

[harshmaul]

have you tried splitting the select into two, ordering them both seperately, and then unioning (if thats a word) them together....

select * from tbl where isFlagged = 't' Order By X
UNION
select * from tbl where isFlagged = 'f' Order By Y
UNION
select * from tbl where isFlagged = null Order By Z

[ronverdonk]

have you tried splitting the select into two, ordering them both seperately, and then unioning (if thats a word) them together....

select * from tbl where isFlagged = 't' Order By X
UNION
select * from tbl where isFlagged = 'f' Order By Y
UNION
select * from tbl where isFlagged = null Order By Z

You cannot ORDER within a UNION select clause.

Ronald