Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

top 10 biggest values? 1

Status
Not open for further replies.
Fursten

Fursten

Programmer
Dec 27, 2000
403
0
0
PT
Hi,

I have a select with a count and a group by.
I need do filter the rows returned to those that have the top 10 biggeste values in the count column. Top 10 only gives the 10 first returned records, and that is not what i need.

thank you
 
Sort by date Sort by votes
Nah, just a really slow turkey...more appropriate. [rofl]
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
148
grnzbra
grnzbra
Cpreston
  • Locked
  • Question
Working Days giving NULL values
Replies
8
Views
179
Cpreston
Cpreston
kingz2000
  • Locked
  • Question
select data with date condition, choosing latest values from selected dates 2
Replies
16
Views
168
Andrzejek
Andrzejek
scabral1979
  • Locked
  • Question
Aggregate Values By Group
Replies
1
Views
77
imex
imex
bmacbmac
  • Locked
  • Question
Inserting XML data into SQLServer returns only NULL values 1
Replies
3
Views
109
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top