\"\"

具体代码:

SELECT * FROM Tkx_Invoice WHERE in_invoice  IN (SELECT in_invoice  FROM [dbo].[Tkx_Invoice] GROUP BY in_invoice  HAVING COUNT(in_invoice )>1);
SELECT COUNT(in_invoice ) AS tcount,in_invoice  FROM Tkx_Invoice GROUP BY in_invoice  HAVING COUNT(*)>1 ORDER BY tcount DESC;

 

收藏 打印