Top ten?
From: Michael Collier <sd345_at_city.ac.uk>
Date: 19 Apr 93 10:00:52 GMT
Message-ID: <sd345.735213652_at_Paddington>
Date: 19 Apr 93 10:00:52 GMT
Message-ID: <sd345.735213652_at_Paddington>
Sorry if this is a FAQ.
Suppose I am doing a group by query which returns lots of rows but I want the
top ten (say).
ie. select something, count(*)
I'd like the top ten something's, how do I do this?
from a_table
group by something
order by something;
Thanks in advance. Michael.
--
Michael Collier (Programmer) The Computer Unit,
Email: M.P.Collier_at_uk.ac.city The City University,
Tel: 071 477-8000 x3769 London,
Fax: 071 477-8565 EC1V 0HB.
Received on Mon Apr 19 1993 - 12:00:52 CEST