m0_37951794的博客

mysql常用且易混淆函数整理

【代码】mysql查看库里有多少张表?

【代码】根据已有的日历表，输入月份，查询该月每天属于星期几，结果展示成日历的样式。

SQLyog 各类操作快捷键

mysql-取金额在排名前75%的数据

mysql-取每个类型里，金额在该类型中排名前75%的数据

select '001' as 部门，100 as 金额，'aaa' as 类型 from dual。select '002' as 部门，100 as 金额，'eee' as 类型 from dual。select '004' as 部门，300 as 金额，'ccc' as 类型 from dual。select '001' as 部门，50 as 金额，'aaa' as 类型 from dual。select '003' as 部门，40 as 金额，'bbb' as 类型 from dual。