Given an < ...
Site Language: English
Terms and Conditions
id, chef_id, salary
fields - how to select all employees whose salary is greater than that of their chief?
select a.* from employee a, employee b where b.id = a.chief_id and a.salary > b.salary
select a.* from employee a, employee b where b.id = a.chief_id and a.salary >= b.salary
Get an explanation when it's available:
Suppose table A has 5 rows and table B has 6 rows. You perform a c...
Suppose table A has 7 rows and table B has 3 rows. You perform a c...
JOIN, CROSS JOIN, and INNER JOIN in MySQL
CARTESIAN JOIN or CROSS JOIN
INNER JOIN example
Login to learn SQL
Read more about
What is the proper syntax of the keyword LIMIT to display 5 result...
What is the proper syntax of the keyword LIMIT to display 8 result...
What is an alternate way of writing the following statement: WHERE "...
Choose correct clause: SELECT CountryCode, COUNT(*) FROM City GROUP ...
Which of the following DROP statements is incorrect?...
What is the name of the category of functions used to summarize data?...
Sign Up Now
Subscribe for future quizzes