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

Re: need help with ordering groups of records

Newsgroups	comp.databases.ms-sqlserver
Date	2013-04-23 05:19 -0700
References	<c2fb326a-1dee-4d93-b41e-16e00868c506@googlegroups.com>
Message-ID	<6957ef41-d7dc-492d-9ad2-e5a21b963965@googlegroups.com> (permalink)
Subject	Re: need help with ordering groups of records
From	Gints Plivna <gints.plivna@gmail.com>

Show all headers | View raw

ceturtdiena, 2013. gada 18. aprīlis 04:21:02 UTC+3, migurus rakstīja:
> I have a list of customers and addresses they have visited, each record has a count of visits. I need to re-sort the list in such a way that customers with higher counts will be higher on the list, but all his/her records should stay together
> 
[skipped]
> 
> As you see, Juan Silva has 225 visits, which is highest of them all, so all his records are sorted before everybody else. The order of records within group belonging to the same customer is not important.
> 
> 
> 
> Any hint or idea would be appreciated.


select * from @t t
order by MAX(cnt) OVER (PARTITION BY NAME) desc, cnt desc

Gints Plivna
http://www.gplivna.eu

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next 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