/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 vote176 views1 answer
Window function to forward fill
SQL
1 vote169 views1 answer
Sql pick random row
SQL
4 votes165 views1 answer
Check database name postgresql
SQL
0 vote162 views1 answer
C# mysql update statement set value to null
SQL
0 vote185 views1 answer
How to map sql column to custom names
SQL
0 vote160 views2 answers
Sql join on wildcard
SQL
1 vote213 views1 answer
Psql client write to bash variable
SQL
3 votes171 views2 answers
Install mysql powershell
SQL
3 votes256 views3 answers
Mysql get table size
SQL
0 vote138 views1 answer
Query for maximum salary
SQL