Forums before death by AOL, social media and spammers... "We can't have nice things"
| comp.databases.ms-sqlserver | Notorious Rube Goldberg contraption | 19,505 messages |
[ << oldest | < older | list | newer > | newest >> ]
| Message 18,868 of 19,505 |
| rja.carnegie@gmail.com to Gints Plivna |
| Re: need help with ordering groups of re |
| 30 Apr 13 11:37:16 |
On Tuesday, 23 April 2013 13:19:15 UTC+1, Gints Plivna wrote: > ceturtdiena, 2013. gada 18. aprīlis 04:21:02 UTC+3, migurus rakstīja: > > Any hint or idea would be appreciated. > > select * from @t t > order by MAX(cnt) OVER (PARTITION BY NAME) desc, cnt desc I can never remember how you do one of those! ;-) --- SoupGate-Win32 v1.05 * Origin: you cannot sedate... all the things you hate (1:229/2) |
(c) 1994, bbs@darkrealms.ca