dBforums - View Single Post - How Can I obtain the Top 3 of a dataset

Thread: How Can I obtain the Top 3 of a dataset

View Single Post

#2 (permalink)

02-09-05, 12:30

HardCode

Registered User

Join Date: Oct 2004

Location: New Jersey

Posts: 65

Once you have your SQL set up to return the sales dollars for all of the locations, just add TOP 3 before the select:

Code:

 SELECT TOP 3 Sum(Dollars) FROM MyTable;

Note that you can also SELECT TOP n PERCENT.

__________________
Retired Moderator at Xtreme VB Talk, for all of your Visual Basic needs.