Groups > comp.databases.ms-sqlserver > #1461

Re: need help with ordering groups of records

Newsgroups	comp.databases.ms-sqlserver
Date	2013-04-30 11:37 -0700
References	<c2fb326a-1dee-4d93-b41e-16e00868c506@googlegroups.com> <6957ef41-d7dc-492d-9ad2-e5a21b963965@googlegroups.com>
Message-ID	<239d1fd2-f7b6-4736-9712-0238acc848ff@googlegroups.com> (permalink)
Subject	Re: need help with ordering groups of records
From	rja.carnegie@gmail.com

Show all headers | View raw

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!  ;-)

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

need help with ordering groups of records migurus <migurus@yahoo.com> - 2013-04-17 18:21 -0700
  Re: need help with ordering groups of records rja.carnegie@gmail.com - 2013-04-17 19:56 -0700
    Re: need help with ordering groups of records migurus <migurus@yahoo.com> - 2013-04-30 10:14 -0700
  Re: need help with ordering groups of records Gints Plivna <gints.plivna@gmail.com> - 2013-04-23 05:19 -0700
    Re: need help with ordering groups of records migurus <migurus@yahoo.com> - 2013-04-30 10:13 -0700
    Re: need help with ordering groups of records rja.carnegie@gmail.com - 2013-04-30 11:37 -0700

csiph-web