这样得sql语句如何写? Select top 1 ID from 表 a where not exists (Select ID from 表 where ID = a.ID + 1) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Select min(ID)+1 as id from 表 a where not exists (Select 1 from 表 where ID = a.ID + 1) select min(id) from(select *,(select count(*) from ABC where id<=XXX.id) as row from ABC as XXX order by id) as yyy where id<>row or:Select top 1 ID+1 as id from 表 a where not exists (Select ID from 表 where ID = a.ID + 1)order by id select min(id)-1 from(select *,(select count(*) from ABC where id<=XXX.id) as row from ABC as XXX order by id) as yyy where id<>row select top 1 ID from 表 a where not exists (select 1 from 表 where ID = a.ID+1)order by ID Select min(ID) from 表 a where not exists (Select 1 from 表 where ID = a.ID + 1) 请教一个SQL语句 在性能查看器中,怎么查看“是哪个数据库占用的CPU资源多”? 求助一个多表汇总的问题 请高手赐教 关于数据表复制到另外一个数据表 着急!!怎样读取这种数据??(在线等待,解决后马上给分!!) 求一触发器写法 如何实现自然语言查询 如何删除SQLServer数据库的日志? sql server里面如何操作图片,大虾帮忙!!!!!!!!! 求救!数据库备份恢复的问题! sos 在线等待
where not exists (Select 1 from 表 where ID = a.ID + 1)
(select *,(select count(*) from ABC where id<=XXX.id) as row from ABC as XXX order by id) as yyy where id<>row
Select top 1 ID+1 as id from 表 a
where not exists (Select ID from 表 where ID = a.ID + 1)
order by id
(select *,(select count(*) from ABC where id<=XXX.id) as row from ABC as XXX order by id) as yyy where id<>row
where not exists (select 1 from 表 where ID = a.ID+1)
order by ID
where not exists (Select 1 from 表 where ID = a.ID + 1)