/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

0 vote278 views1 answer
T-sql conditional order by multiple columns
SQL
0 vote324 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote285 views2 answers
Drop check constraint in ms sql
SQL
0 vote307 views1 answer
Basic structure of sql expression having clause
SQL
0 vote308 views1 answer
Microsoft sql server python connection
SQL
3 votes280 views1 answer
Make a field auto_increment mysql
SQL
0 vote308 views1 answer
How to query without duplicate rows in sql
SQL
1 vote283 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote290 views1 answer
Declarative base sqlalchemy
SQL
1 vote289 views2 answers
Rebuild index sql server
SQL