/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

3 votes324 views1 answer
Oracle nextval
SQL
0 vote349 views1 answer
Oracle date summer time
SQL
0 vote337 views1 answer
Alter table fulltext
SQL
2 votes305 views1 answer
Oracle sql drop column if exists
SQL
6 votes352 views2 answers
Clear a table in mysql
SQL
1 vote348 views2 answers
Install mysqldump ubuntu
SQL
0 vote330 views1 answer
If null don't update
SQL
0 vote345 views1 answer
Default value false mysql
SQL
2 votes377 views1 answer
Sql percentage with % rounded down
SQL
0 vote374 views1 answer
How to move a columns location in mysql
SQL