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

Re: need help with ordering groups of records

X-Received	by 10.224.178.205 with SMTP id bn13mr22506247qab.3.1366719555661; Tue, 23 Apr 2013 05:19:15 -0700 (PDT)
X-Received	by 10.49.2.170 with SMTP id 10mr2691760qev.40.1366719555637; Tue, 23 Apr 2013 05:19:15 -0700 (PDT)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!gp5no1824360qab.0!news-out.google.com!ef9ni833qab.0!nntp.google.com!gp5no1824352qab.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Tue, 23 Apr 2013 05:19:15 -0700 (PDT)
In-Reply-To	<c2fb326a-1dee-4d93-b41e-16e00868c506@googlegroups.com>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=94.101.225.18; posting-account=yUnXAgoAAAAtYWXOhuy56byPUjMGOID6
NNTP-Posting-Host	94.101.225.18
References	<c2fb326a-1dee-4d93-b41e-16e00868c506@googlegroups.com>
User-Agent	G2/1.0
MIME-Version	1.0
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>
Injection-Date	Tue, 23 Apr 2013 12:19:15 +0000
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	quoted-printable
Xref	csiph.com comp.databases.ms-sqlserver:1452

Show key headers only | 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