一条sql 问题
0
[已解决问题]
解决于 2009-06-29 14:16
表A：
BOOK是字段
A
B
C
D
E
B
C
要输出的结果是：
BOOK SUMCOUNT
B 2
C 2
最佳答案
0
select distinct BOOK ,count(BOOK) as 'SUMCOUNT' form A group by
BOOK having count(book)>1
其他回答(3)
0
SELECT DISTINCT BOOKID ,COUNT(BOOKID) AS 'SUMCOUNT'
FROM DBO.BOOK GROUP BY
BOOKID HAVING BOOKID IN('B','C')
这是最最基本的Group by,属于面试必考.
0
看一下分组的SQL语句就可以了。
0
select distinct Book ,count(Book) from A
group by Book
having count(Book) > 1
