越简单越好！简单的统计

3107869

表格如下：
id num
11  12
12  12
13  13
14  88
15 10
..  ..

num有可能重复。

求：num最小（大）的id数目
2/1

blackhalo

--try
select count(*) from table  a where a.num=(select min(num) from table )
group by num

尉迟普贤

select count(*) 'num最小的id數目' from 表
where id =(select min(num) from 表)

暫時只想到上面的蠢方法

尉迟普贤

+個 AS

select count(*) AS 'num最小的id數目' from 表
where id =(select min(num) from 表)

暫時只想到上面的蠢方法

我是杀人狂

select count(*) from tablename  where num in (select min(num) as num from tablename )

pguppgdn

select count(1) from table a where exists(select 1 from table where num>a.num) group by a.num

wgfxman

呵呵。。都是正解

yjws121

select top 1 from table order by num asc(/desc)  --

yjws121

select top 1 * from table order by num asc(/desc)  --

yjws121

select count(*) from xx where num=(select top 1 num from xx order by num desc)