Re: SQL Question
From: heyzz <heyzz_at_371.net>
Date: 2000/07/16
Message-ID: <8kr1qh$2j22$1_at_news.cz.js.cn>#1/1
Date: 2000/07/16
Message-ID: <8kr1qh$2j22$1_at_news.cz.js.cn>#1/1
[Quoted] oh, sorry, I make a mistake. that is for sql server. and it is for oracle:
[Quoted] select * from (
[Quoted] select * from table_name order by count desc ) where rownum <=10; Received on Sun Jul 16 2000 - 00:00:00 CEST