?求写一条sql语句:SQL server 怎么实现Sybase 这样的功能?
yling 2001-11-27 10:13:36 在Sbyase中:
select * from table_1 group by dt,id,num having count(num) > 1
但在SQL Server 中我只能实现:
select dt,id,num from table_1 group by dt,id,num having count(num) > 1
怎么能把table_1中的其他字段也一起select出呢?
怎么实现??????方法不限
thanks a lot
得到答案立即结账:)呵呵