es查询语句 sql语句查询语法？

sql语句查询语法？

1:select s#，sn from s，c，sc where s.s#=sc.s# and c.c#=sc.c# and c.cn="税收基础"2:select sn，sd from s，c，sc where s.s#=sc.s# and c.c#=sc.c# and c.c#="C2"3:select sn，sd from s，c，sc where s.s#=sc.s# and c.c#=sc.c# and c.c#!="C5"4:select * 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)5: select count(tt.*) from (select s#，sn from s，c，sc where s.s#=sc.s# and c.c#=sc.c# group by s#，sn) as tt6:select * 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) 刚写的，希望能帮到你。

es查询语句 elasticsearch搜索语法 kibana 查询语法示例

版权声明：本文内容由互联网用户自发贡献，本站不承担相关法律责任.如有侵权/违法内容,本站将立刻删除。