Want to use order by clause with this query

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Want to use order by clause with this query

Author

Topic

pareekfranksoul
Starting Member

26 Posts

Posted - 2009-05-13 : 02:22:29

Friends,

I Want to use order by (Order By T1 desc) clause with this query:

select Fname,Sum(A) as T1, Sum(B)as T2 from tbl_Selection group by Fname

Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-13 : 02:36:11

order by sum(a) desc

E 12°55'05.63"
N 56°04'39.26"