PDA

View Full Version : Solved: sql qurey to arrange by months



shamsam1
08-22-2008, 05:15 AM
i have month table with data type varchar
month1
January
march
December
February
October
September
may
march

i want sql query to arrange month according to month list(jan,feb,march,april):think:

Mavyak
08-22-2008, 06:26 AM
ORDER BY
CASE MONTH_FIELD
WHEN 'JANUARY' THEN '1'
WHEN 'FEBRUARY' THEN '2'
...
...
...
END

shamsam1
08-22-2008, 06:37 AM
PERFECT ,IF I USE ORDERBY COMMAND I CAN'T USE DISTINCT ANY SUGGESTION ON THIS

Mavyak
08-22-2008, 07:31 AM
Use GROUP BY instead.

shamsam1
08-22-2008, 07:35 AM
thanks for solving the problem