select count(fprojid),fprojid as number from bill_item group by fprojid
怎么样才能找到count(fprojid)>1的fprojid的数据

用exists来计算呀

[此贴子已经被作者于2006-10-30 16:50:35编辑过]

select fprojid as 'number' from bill_item where count(fprojid)>1

[此贴子已经被作者于2006-10-30 20:22:37编辑过]

select count(fprojid),fprojid as number from bill_item group by fprojid
怎么样才能找到count(fprojid)>1的fprojid的数据

select fprojid as [number] , count(*) from bill_item group by fprojid having count(*) > 1

你是在查重复的fprojid吧?

谢谢，