Re: SQL Question
From: heyzz <heyzz_at_371.net>
Date: 2000/07/16
Message-ID: <8kr1ne$2iv7$1_at_news.cz.js.cn>#1/1
Date: 2000/07/16
Message-ID: <8kr1ne$2iv7$1_at_news.cz.js.cn>#1/1
select top 10 * from table_name order by count desc
"Vikram Dayanidhi" <vikran_at_Bayou.UH.EDU> wrote in message
news:Pine.OSF.3.95q.1000715154528.5145A-100000_at_Bayou.UH.EDU...
> How do I select the rows containing the largest 10 counts from the
> following table:
>
> id count
> ------ ----------
> 1 23
> 2 45
> 3 12
> 4 33
> 5 26
> 6 31
> 7 09
> 8 89
> 9 77
> 10 76
> 11 48
> 12 98
> 13 63
> 14 29
> 15 29
> 16 83
> 17 18
> 18 28
>
> TIA
> Vikram
>
Received on Sun Jul 16 2000 - 00:00:00 CEST