查詢一個表裡某列有重復的記錄總數？(50分)

康仔 · 2006-02-13

查詢一個表裡某列有重復的記錄總數？
(即如何獲得下面select 語句結果的總行數)
select pro_id,count(*) from stock group by prod_Id having count(*)>1 ordery by prod_id

zhenshide · 2006-02-13

select count(*) from
(select pro_id,count(*) from stock group by prod_Id having count(*)>1)
把ordery by prod_id 去掉

康仔 · 2006-02-13

不行啊，我用的是SQLServer，Oracle可能行

寂寞的鸭子 · 2006-02-13

有什么不行的，SQLServer和Oracle都可以这么写的

tone2003 · 2006-02-13

select count(pro_ID) from stock Where Proid in (select pro_id from stock group by prod_Id having count(*)>1)

寂寞的鸭子 · 2006-02-13

不好意思，刚测试了一下，楼上的SQL语法有点问题，改成下面的就可以了
select count(icount) from (select count(*) icount from jobs group by min_lvl having count(*) > 1) a

康仔 · 2006-02-14

謝了，鴨子!

康仔 · 2006-02-14

多人接受答案了。