https://www.cnblogs.com/zhangpengnike/p/5545715.html
https://www.nowcoder.com/ta/sql?from=baidusql&bd_vid=1697450650721029667
mysql sql语句大全(MySQL语句 整理一)
MySQL 部门 员工数量查询 查询部门员工数量并按部门、数量2个字段显示
mysql sql语句一次性查出每个部门男女多少人----sum和case用法案例。
select *,if(sva=1,"男","女") as ssva from taname where sva<>""
mysql> SELECT IF(0.1<>0,1,0);
-> 1
创建数据库,创建数据库表,例子。MySQL语句
select * from table1 t where (select count(*) from table1 where column1=t.column1 AND column2=t.column2 and column3=t.column3)>1