Re: Tricky SQL question

From: Vagelis Rados <Vrados_at_Singular.gr>
Date: Mon, 04 Jan 1999 08:38:05 GMT
Message-ID: <36907d77.5170628@news-ath.forthnet.gr>

change the sql statement to:

	select distinct (keyword), count(keyword)
	from keyword k
	where rownum < 11
	group by keyword
	order by 2 desc;

The Usage of the pseudo column ROWNUM eliminates the output of the wuery to 10 rows.
Regards,

---

Vagelis Rados
Singular Computer Applications
mail to : vrados_at_singular.gr
Web Site : http://www.singular.gr Received on Mon Jan 04 1999 - 02:38:05 CST