Solved: sql qurey to arrange by months

[shamsam1]

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)

[Mavyak]

ORDER BY
CASE MONTH_FIELD
WHEN 'JANUARY' THEN '1'
WHEN 'FEBRUARY' THEN '2'
...
...
...
END

[shamsam1]

PERFECT ,IF I USE ORDERBY COMMAND I CAN'T USE DISTINCT ANY SUGGESTION ON THIS

[Mavyak]

Use GROUP BY instead.

[shamsam1]

thanks for solving the problem