/SQL/Sql query interview questions githu

Sql query interview questions githu

SELECT e.name AS 'Employee Name', e2.name AS 'Boss', 
e.salary AS 'Employee salary', e2.salary AS 'Boss salary'
FROM employees e
JOIN employees e2 ON e.boss_id = e2.employee_id
WHERE e2.salary < e.salary;

Source: gist.github.com

Similar codes

9 votes212 views3 answers
Where in sql
SQL
0 vote709 views1 answer
Mysql custom sort order
SQL
4 votes215 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote216 views1 answer
How to get initials in sql
SQL
79 votes393 views6 answers
Grepper code
SQL
0 vote211 views1 answer
Price-colour
SQL
0 vote222 views1 answer
Sql server concat null
SQL
0 vote207 views1 answer
Like and not like together in sql
SQL
4 votes210 views4 answers
Update select mysql
SQL
0 vote226 views1 answer
Oracle query archive mode
SQL