`

常用sql语句

SQL 
阅读更多

select  name from student where name not in (select  name from student where scount<=100)

 

select distinct name from student where scount<=80

select name from student where scount<=80

select distinct name  from student where name not in(select distinct name from student where scount<=80)


select distinct name from student where scount>80

delete from student where classid not in(select min(classid) from student group by classid)

分享到：
| ZK框架学习总结
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

Magicbox
Global site tag (gtag.js) - Google Analytics