select ... from ... group by ... having count(*) > 1;
搞掂了这样写: Select TB_CallerID,TB_ServiceTime,TB_StartTime From TEMP_TELEBILL Where TEMP_TELEBILL.Rowid In (Select a.Rowid From TEMP_TELEBILL a,TEMP_TELEBILL b Where a.tb_callerid=b.TB_CALLERID And a.TB_BILLINGREFID<>b.TB_BILLINGREFID And a.TB_SEQID<>b.TB_SEQID) Order By Tb_CallerID 这样就可以把相同Tb_CallerID的纪录找出来了。
Select TB_CallerID,TB_ServiceTime,TB_StartTime From TEMP_TELEBILL Where TEMP_TELEBILL.Rowid In (Select a.Rowid From TEMP_TELEBILL a,TEMP_TELEBILL b Where a.tb_callerid=b.TB_CALLERID And a.TB_BILLINGREFID<>b.TB_BILLINGREFID And a.TB_SEQID<>b.TB_SEQID) Order By Tb_CallerID
这样就可以把相同Tb_CallerID的纪录找出来了。