Question

sql语法中count 用法

SELECT
vcani,count(*) as a
FROM [Ssd_FeeStat].[dbo].[SSD_FeeData_0571_2012] group by vcani order by a
这个搜索结果中，我想知道count(*)后>10的列出来 怎么修改？

Answer 1

select * from

(
SELECT t.cfbillfrom,count(*) as a
FROM ct_ope_waybill t
group by t.cfbillfrom
order by a
) b

where b.a>10

Answer 2

SELECT
vcani,count(*) as a
FROM [Ssd_FeeStat].[dbo].[SSD_FeeData_0571_2012] group by vcani having count(*)>10

Answer 3

select * from
(SELECT
vcani,count(*) as a
FROM [Ssd_FeeStat].[dbo].[SSD_FeeData_0571_2012] group by vcani order by a) A
where A.a>10

追问

错误：除非另外还指定了 TOP 或 FOR XML，否则，ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。

追答

select * from
(SELECT
vcani,count(*) as a
FROM [Ssd_FeeStat].[dbo].[SSD_FeeData_0571_2012] group by vcani ) A
where A.a>10 order by a