不知道这样的语句怎么写

[medusalee1]

想问问怎样获取某一列出现次数最多的前3个值
比如某一列：
VALUE
3
1
4
1
1
3
1
2
4

那么出现最多的前3个值是1 3 4
sql 语句该怎么写呢

[zhengshaodong]

DECLARE @tb TABLE ([val] int)
INSERT INTO @tb SELECT 1
UNION ALL SELECT 1
UNION ALL SELECT 2
UNION ALL SELECT 3
UNION ALL SELECT 4
UNION ALL SELECT 5
UNION ALL SELECT 2
UNION ALL SELECT 2

SELECT TOP 3 [val],count(1) AS valCount FROM @tb
GROUP BY [val]
ORDER BY count(1) desc

[lihan6415151528]

create table test(value int)
insert test 
select 3 union all
select 1 union all
select 4 union all
select 1 union all
select 1 union all
select 3 union all
select 1 union all
select 2 union all
select 4 
go

select top 3 value  from test
   group by value
order by count(value) desc


value       
----------- 
1
4
3

（所影响的行数为 3 行）