Is it Possible?

[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.

 

[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