Try Mailstrom: the faster, smarter, free way to Inbox Zero.

Replyz collects and amplifies questions from around the web, allowing a wider audience to answer them.

Share your knowledge and build your reputation by posting helpful replies.

@grrl_geek

Follow This User

#sqlhelp I have gotten as far as SUM(Sales) OVER(PARTITION BY Division). That pulls back all custs for all divisions. How do I get top 10?

3:09PM Wed, April 21 2010

@Adam_Haines

filter the cte by the row num column aliased in the cte earlier e.g. where rownum <=10 #sqlhelp

3:11PM Wed, April 21 2010

@grrl_geek

Do you have an example?

3:14PM Wed, April 21 2010

@DenisGobo

kind of difficult to do with twitter...give me a sec

3:16PM Wed, April 21 2010

@rhurwitz

use a RANK() over (PARTITION BY division) as [rank] in your select clause

3:17PM Wed, April 21 2010

@Adam_Haines

WITH cte AS(SELECT ,ROW_NUMBER() OVER(PARTITION BY div ORDER BY amt DESC) AS seq FROM @t)SELECT FROM cte WHERE seq <=10

3:22PM Wed, April 21 2010

Anonymous

Follow This Conversation

Related Conversations

If a team can win every division game & not win division, what is the purpose of…

If the NFC South is a "quarterback's division", what are the other divisions? Is…

So I just played someone from Division 3... When im in Division 1. What is the p…

In light of the Big Ten's horrible new division names, perhaps the IFL should re…

Now, what is the Point of Divisions in NFL, when undefeated in your Division, an…

Topics Like This

Conversations about "pulls"

Conversations about "divisions"

Like to reply? Try Flashcards

Flashcards is a quick and fun way to share your knowledge about topics you like to tweet about. Sign in with Twitter and we’ll show you questions you can’t resist!

Get notified when your questions get replies. Track your conversations.

JOIN REPLYZ

Already a Replyz Member?

Connect with Twitter

Replyz collects and amplifies questions from around the web, allowing a wider audience to answer them.

#sqlhelp I have gotten as far as SUM(Sales) OVER(PARTITION BY Division). That pulls back all custs for all divisions. How do I get top 10?

filter the cte by the row num column aliased in the cte earlier e.g. where rownum <=10 #sqlhelp

Do you have an example?

kind of difficult to do with twitter...give me a sec

use a RANK() over (PARTITION BY division) as [rank] in your select clause

WITH cte AS(SELECT *,ROW_NUMBER() OVER(PARTITION BY div ORDER BY amt DESC) AS seq FROM @t)SELECT * FROM cte WHERE seq <=10

Write a Reply

Related Conversations

Topics Like This

Like to reply? Try Flashcards

Ask a question, Start a discussion, Or post anything you want to get replies to.

It’s that simple.

Start a Conversation, Get Replies

WITH cte AS(SELECT ,ROW_NUMBER() OVER(PARTITION BY div ORDER BY amt DESC) AS seq FROM @t)SELECT FROM cte WHERE seq <=10