#二、非等值连接
#查询员工工资级别
SELECT `salary`,`grade_level`
FROM `employees` e
JOIN `job_grades` j
ON e.`salary` BETWEEN `lowest_sal`
AND `highest_sal`;
#查询工资级别的个数>20的个数,并且按工资级别降序
SELECT COUNT(*),`grade_level`
FROM `employees` e
JOIN `job_grades` j
ON e.`salary` BETWEEN `lowest_sal`
AND `highest_sal`
GROUP BY `grade_level`
HAVING COUNT(*)>20
ORDER BY COUNT(*) DESC;
sql99语法--非等值连接
最新推荐文章于 2022-04-21 23:09:31 发布