摘要:
简介 having 的使用考察 select number from grade group by number having count(number) >= 3; 阅读全文
posted @ 2021-07-01 11:13
HDU李少帅
阅读(49)
评论(0)
推荐(0)
摘要:
简介 left join select a.id, a.name, b.content from person as a left join task as b on b.person_id = a.id order by a.id; 阅读全文
posted @ 2021-07-01 11:12
HDU李少帅
阅读(33)
评论(0)
推荐(0)
摘要:
简介 简单 select user_id, max(date) from login group by user_id order by user_id; 阅读全文
posted @ 2021-07-01 11:04
HDU李少帅
阅读(55)
评论(0)
推荐(0)
摘要:
简介 使用 round 与 avg select job, round(avg(score),3) as avg from grade group by job order by avg desc; 阅读全文
posted @ 2021-07-01 11:00
HDU李少帅
阅读(29)
评论(0)
推荐(0)
摘要:
简介 使用 多个 and 并列 select * from order_info where date > "2025-10-15" and status = "completed" and product_name in("C++","Java","Python") order by id; 阅读全文
posted @ 2021-07-01 10:50
HDU李少帅
阅读(46)
评论(0)
推荐(0)
摘要:
简介 select job, sum(num) as cnt from resume_info where resume_info.date < '2026-01-01' and resume_info.date >= '2025-01-01' group by job order by cnt d 阅读全文
posted @ 2021-07-01 10:49
HDU李少帅
阅读(52)
评论(0)
推荐(0)
摘要:
简介 order by 然后 limit select * from employees order by hire_date desc limit 1; 阅读全文
posted @ 2021-07-01 10:36
HDU李少帅
阅读(66)
评论(0)
推荐(0)