摘要:
SELECT s.id, s.name, max(case when g.kemu='语文' then score else 0 end) as 语文,max(case when g.kemu='数学' then score else 0 end) as 数学,max(case when g.kem 阅读全文
摘要:
1.获取当前时间 SELECT NOW() AS nowTime; =》2021-03-12 18:00:03 2.获取天数的时间差 (1) SELECT TO_DAYS(NOW()) - TO_DAYS('20210310') AS days; =》2 (2) SELECT DATEDIFF(NO 阅读全文
摘要:
SELECT COUNT(reg_city) AS customerCount,a.reg_city ,(CAST(CONVERT(100 * CAST(COUNT(*) AS DECIMAL(10,2)) / CAST((SELECT COUNT(*) FROM 表名 ) AS DECIMAL(1 阅读全文