1.where语句一般不能有算术运算的函数,但可以:
select * from table1 as A
where (select count(*) from table1 where id > A.id) > 2
2.having语句大部分在有group by的情况下使用,但可以:
select count(*) from a1 having count(*) > 1
select * from table1 as A
where (select count(*) from table1 where id > A.id) > 2
2.having语句大部分在有group by的情况下使用,但可以:
select count(*) from a1 having count(*) > 1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货