日期:2014-05-19  浏览次数:20331 次

not exists
select   *   from   c1   as   t   where   not   exists((
select   count(*)   from   c1   where   t.score> c1.score)   > 2)
为什么出错?能这样使用吗?

------解决方案--------------------
select * from c1 as t where --not exists
((select count(*) from c1 where t.score> c1.score)> 2)
not exists用法不正确
------解决方案--------------------
--try
select * from c1 as t where (select count(*) from c1 where t.score> c1.score)> 2

------解决方案--------------------
不要用not exists
例如:
if exists(select 1 from sysobjects where id=object_id( 'tablename '))
drop table tablename

也可以写成:
if (select count(1) from tablename )> 0
drop table tablename