T-SQL - SELECT TOP

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Robert Griffin » T-SQL - SELECT TOP

21 posts, Page 3 of 3

«««1 2 3

T-SQL - SELECT TOP

Rate Topic

Display Mode

Topic Options

Author

Message

Lynn Pettis

Posted Thursday, March 19, 2009 11:13 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 21,602, Visits: 27,431

Yes, there are issues with the query itself, but what did the question ask? How do you ensure you get the top 25 in sales. The only answer that works there is that you also need to add an ORDER BY SUM(salesdollars) DESC.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #679688

« Prev Topic | Next Topic »

21 posts, Page 3 of 3

«««1 2 3

Permissions