/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 vote211 views1 answer
Sql delete row from table where id
SQL
1 vote99 views1 answer
Alter user mysql native password
SQL
0 vote149 views1 answer
Mysql update privileges
SQL
8 votes164 views2 answers
How to fetch data from database without last column
SQL
0 vote140 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote149 views1 answer
How to find symmetric pairs in sql
SQL
0 vote150 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote134 views1 answer
Get who is hired in january in sql
SQL
4 votes150 views2 answers
How to insert ip address in mysql using php
SQL
0 vote149 views1 answer
Mysql workbench procedure
SQL