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

Let me tell you a little bit about how the sql99 syntax in mysql implements non-equivalent joins. Have you ever heard of similar topics before? If you are interested, let's take a look at this article. I believe it will be of some help to you after reading how the sql99 syntax in mysql implements non-equivalent connections.

# 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

What do you think of this article on how to achieve non-equivalent joins in sql99 syntax in mysql? If you want to know more about it, you can continue to follow our industry information section.

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.