您现在的位置是：首页 > 新闻 > 正文
sql语句查询(sql语句查询语法)
2022-09-05 04:46新闻
简介 1select sn,sd from s,c,sc where s.s#=sc.s# and c.c#=sc.c# and c.c#='C2'3select * from (select sn,sd,count(s.*) as cc from s,c,sc where s.s#=sc.s# and c.c#=sc.c# and s.s# group by sn,sd) as tt where tt.cc=(select count(*) from c)5select * fr...
1select sn,sd from s,c,sc where s.s#=sc.s# and c.c#=sc.c# and c.c#='C2'3select * from (select sn,sd,count(s.*) as cc from s,c,sc where s.s#=sc.s# and c.c#=sc.c# and s.s# group by sn,sd) as tt where tt.cc=(select count(*) from c)5select * from (select sn,sd,count(s.*) as cc from s,c,sc where s.s#=sc.s# and c.c#=sc.c# and s.s# group by sn,sd) as tt where tt.cc>=5) 刚写的，希望能帮到你。
