The simpler the better! Simple statistics

3107869

The table is as follows:
id num
11 12
12 12
13 13
14 88
15 10
.. ..

num may be repeated.

Find the number of IDs with the smallest (large) num
2/1

blackhalo

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

尉迟普贤

select count(*)'num minimum id number' from table
where id = (select min(num) from table)

Only think of the above stupid method for the time being

尉迟普贤

+ AS

select count(*) AS'num minimum id number' from table
where id = (select min(num) from table)

Only think of the above stupid method for the time being

我是杀人狂

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

Ha ha. . All positive solutions

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)