sefas Posted January 19, 2012 Share Posted January 19, 2012 I am trying to use the ORDER BY CASE sql statement in my report query to sort data in a specific order, but it does not like the syntax. In oracle the syntax is e.g.order by case when order_type = 12 then 1 when order_type = 10 then 2 else 3 endAny idea what the correct syntax is to do this in the Report query?. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now