Is it Possible? (1 Viewer)

[asp_learner]

Hi,

I asked this a few weeks ago but never got an answer. In SQL, is it possible to do a Select Top 10 By Person.

Thanks,
Eva

 

[jatfill]

yes... just start with
SELECT TOP 10

& the rest of your statement...

If your doing sums or other calculations, just use the GROUP BY function on the Person.

 

[Pat Hartman]

Either solutions.mdb or qrysmp97.mdb or rptsmp97.mdb have a sample of how to do this. Solutions.mdb is available in the installation cd for Access 97 and older. The other two sample db's are available at the Microsoft download site: http://www.microsoft.com/downloads/search.asp

 

[asp_learner]

Thank you both. I will look at the sample, I had tried to do it the way I had mentioned but for some reason I had run into an error. Now that I know it is doable I will look at the samples.

Eva