eaweb
asked on
order by month and year in sql
hi,
i am using below query
SELECT DISTINCT Month(STMTR_D) as stmMonth, Year(STMTR_D) as stmYear
FROM STMTR where STMTR_AN = '12345'
and STMTR_BI = '01' order by Month(STMTR_D) asc,Year(STMTR_D) asc
which gives me as output
stmMonth stmYear
1 2009
2 2009
10 2008
11 2008
12 2008
how must i change the query in order to get the output like:
stmMonth stmYear
2 2009
1 2009
12 2008
11 2008
10 2008
i am using below query
SELECT DISTINCT Month(STMTR_D) as stmMonth, Year(STMTR_D) as stmYear
FROM STMTR where STMTR_AN = '12345'
and STMTR_BI = '01' order by Month(STMTR_D) asc,Year(STMTR_D) asc
which gives me as output
stmMonth stmYear
1 2009
2 2009
10 2008
11 2008
12 2008
how must i change the query in order to get the output like:
stmMonth stmYear
2 2009
1 2009
12 2008
11 2008
10 2008
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SELECT DISTINCT Month(STMTR_D) as stmMonth, Year(STMTR_D) as stmYear
FROM STMTR
where STMTR_AN = '12345'
and STMTR_BI = '01'
order by Year(STMTR_D) desc, Month(STMTR_D) desc
This will do