这个sql语句好难写 select * from table1 where (select count(*) from table1) = (select count(*) from table1 where a3 = 1) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from table1,(select count(*) as idd from table1 where a3='1') a,(select count(*) as idd from table1) b where a.idd=b.idd select * from table1 where not exists(select 1 from table1 where a3<>'1') Select * from table1 where not exists(select * from table1 where a3 <> '1') select * from table1 where not exists(select 1 from table1 where a3<>'1') select * from table1 where exists(select 1 from table1 where a3='1') select * from table1 where exists(select 1 from table1 where a3='1') 同意tj_dns(愉快的登山者) select * from table1 where (select count(*) from table1) = (select count(*) from table1 where a3 = 1) : tj_dns(愉快的登山者) hjb111(唐老鸭) maoxianqiang(sky)myflok(阿棋) txlicenhe(马可@李) (正确。。向你们学习,有更好的SQL的请上帖,继续给分 select * from table1 where not exists(select 1 from table1 where a3<>'1') select * from table1 where not exists(select 1 from table1 where a3<>'1') 请教分组统计的SQL? 加约束的问题``` 创建的视图如何添加第一项是自动编号? sql 的一个疑难杂症,有可能是这样吗?大牛请进! 两表关联问题 如何使用临时表 SQL server 2000 在xp下可以用吗? 急问用vc连接SQL server数据库!给100分! vfp6.0菜单问题 SQLDMO:How to initialize QueryResults(object) SQL Sever的表最多能让建多少个字段,字段多了,对速度和安全性、稳定性有影响吗? 请pengdali(大力 V2.0) , tj_dns(愉快的登山者) 两位兄台进来领分。顺便再问一题。
table1,(select count(*) as idd from table1 where a3='1') a,(select count(*) as idd from table1) b
where a.idd=b.idd
select * from table1
where (select count(*) from table1) = (select count(*) from table1 where a3 = 1)
hjb111(唐老鸭)
maoxianqiang(sky)
myflok(阿棋)
txlicenhe(马可@李) (正确。。
向你们学习,有更好的SQL的请上帖,继续给分