/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 vote198 views1 answer
Psql filed name alter
SQL
0 vote202 views1 answer
Mysql drop trigger
SQL
1 vote277 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote204 views1 answer
Mysql count by month
SQL
7 votes247 views1 answer
Show line number in sql server
SQL
0 vote194 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote216 views1 answer
Uncheck constraints and delete from table
SQL
0 vote234 views1 answer
Look at running processes redshift
SQL
0 vote203 views1 answer
Update view sql
SQL
1 vote197 views2 answers
Setval max id postgresql sequence
SQL