/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

1 vote255 views1 answer
Pgsql sum switch case
SQL
10 votes200 views1 answer
How to import database in mysql by cmd
SQL
0 vote218 views1 answer
Stop psql server windows
SQL
16 votes246 views6 answers
Insert sql
SQL
3 votes200 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote235 views1 answer
Sql tablo sp
SQL
0 vote267 views1 answer
Last date for each user sql
SQL
0 vote188 views1 answer
Sql cursor example multiple columns
SQL
0 vote187 views1 answer
Pip install mysqlclient error
SQL
0 vote188 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL