UPDATE userinfo SET salary=salary+100 WHERE username=‘王五’
SELECT dept AS ‘超过两人的部门’,COUNT(dept) AS ‘人数’ FROM userinfo GROUP BY dept HAVING (COUNT(dept)>=2);
SQL面试(2)
最新推荐文章于 2022-11-10 11:50:42 发布
UPDATE userinfo SET salary=salary+100 WHERE username=‘王五’
SELECT dept AS ‘超过两人的部门’,COUNT(dept) AS ‘人数’ FROM userinfo GROUP BY dept HAVING (COUNT(dept)>=2);