34,838
社区成员




IF(OBJECT_ID('TEMPDB..#T') IS NOT NULL)
BEGIN
DROP TABLE #T
END
CREATE TABLE #T
(
[CODE] NVARCHAR(100)
)
INSERT INTO #T SELECT [CODE]='..a..'
INSERT INTO #T SELECT [CODE]='..a..'
INSERT INTO #T SELECT [CODE]='..b..'
INSERT INTO #T SELECT [CODE]='..b..'
INSERT INTO #T SELECT [CODE]='..b..'
INSERT INTO #T SELECT [CODE]='..c..'
INSERT INTO #T SELECT [CODE]='..c..'
INSERT INTO #T SELECT [CODE]='..c..'
INSERT INTO #T SELECT [CODE]='..c..'
SELECT TOP 1 [CODE],COUNT(*) AS [COUNT] FROM #T GROUP BY [CODE] ORDER BY [COUNT] DESC
----------------------------
CODE COUNT
..c.. 4
select max(num) from (select col,count(1) as num from tb group by col)t
declare @tb table (px nvarchar(10))
insert into @tb select 'a'
union all select 'a'
union all select 'b'
union all select 'b'
union all select 'b'
union all select 'c'
union all select 'c'
union all select 'c'
union all select 'c'
select max(次数) from
(select px, count(*) 次数 from @tb group by px) tb
----------
4
declare @table table (CName varchar(5))
insert into @table
select '..a..' union all
select '..a..' union all
select '..b..' union all
select '..b..' union all
select '..b..' union all
select '..c..' union all
select '..c..' union all
select '..c..' union all
select '..c..'
select top 1 CName,COUNT(CName) as CnameCount from @table
group by CName order by COUNT(CName) desc
/*
CName CnameCount
----- -----------
..c.. 4
*/
select max(num) from (select col,count(1) as num from tb group by col)t
select max(num) from (select col,count(1) as num from tb group by col)AS T
select top 1 * from (select col,flag=count(1) as num from tb group by col)t
order by flag
select max(num) from (select col,count(1) as num from tb group by col)