Shulou(Shulou.com)06/01 Report--

# case: query the salary level of an employee

SELECT salary,grade_levelFROM employees eJOIN job_grades gON e.`salary`BETWEEN g.`lowest _ sal`AND g.`lowest _ sal`

# case: query the number of each salary grade and descend by rank

SELECT COUNT (*), grade_levelFROM job_grades jJOIN employees eON e.`salary`BETWEEN j.`lowest _ sal`and j.`highest _ sal`GROUP BY grade_level DESC

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.