求助一简单SQL语句,谢谢 select col1,col2,col3 from table1 where col2=6 or col2=7 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from tablename where col2 in (select col2 from tablename group by col2 having count(*)>1 ) select * from table where col2 in (select col2 from table where count(*)>1 group by col2) order by col2 应该是有重复行的吧!select * from tablename where col2 in (select col2 from tablename group by col2 having count(*)>1 ) select * from table1 where col2=6 or col2=7 select * from Table1 where col2 in(select col2 from table1 group by col2 having count(col2)>1) order by col2 select col1,sol2,col3 from table where col2>5 order by col2 SQL中查询操作记录(日志)的方法有哪些? 一句多对多关系的sql写法 MSSQLserver2000,Windows2003,访问数据库权限问题: 水晶报表里面当数据库专家中有两个表时候,老是会弹出数据库登陆 对话框。如果一个表的话就很正常。这是什么原因啊。。 自动组卷难题求助 好难的delete!!大家帮忙啊! 怎么统计重复的行数? 数据类型转换问题?NVarChar到double 用UPDATE 这个sql 怎么写 请问如何打开加密的Word 97文档 这段trigger的代码有问题吗?在线等待,马上送分 小问题:数据库里的字段类型是binary(20),我怎么把它显示出来??
(select col2 from tablename group by col2 having count(*)>1 )
select * from tablename where col2 in
(select col2 from tablename group by col2 having count(*)>1 )
where col2 in(select col2 from table1 group by col2 having count(col2)>1)
order by col2