Distinct with Orderby

[livezone]

Hi,

If I ran the following query it gives me the month name in Alapabetical order like

SELECT Distinct useMonthName FROM dbo.Summary
Apr
Feb
Jan
Jul

I have a column name useYear and useMonth (1,2,3). I still want to use distinct MonthName but want my results to be sorted by useMonth (1,2,3) instead of alphabetical sorting.

Please help
Thanks
Shafiq

 

[SQLBill]

Add:

ORDER BY UseMonth ASC

-SQLBill

Posting advice: FAQ481-4875

 

[livezone]

Server: Msg 145, Level 15, State 1, Line 1
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

And my problem is that I just need to show only one column which is MonthName

 

[gmmastros]

Does this work for you?

Select useMonthName
From   (
       SELECT Distinct useMonthName, UseMonth 
       FROM dbo.Summary 
       )
Order By useMonth

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[DotNetGnat]

that should be:

ORDER BY [red]UseMonthName[/red] ASC

-DNG

 

[DotNetGnat]

oops...i think i am wrong..sorry got confused

-DNG