/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 vote268 views1 answer
Update top 100 sql
SQL
0 vote291 views1 answer
Sql get date from timestamp
SQL
0 vote268 views1 answer
Select other columns with distinct
SQL
1 vote273 views1 answer
T-SQL Alter the column data type
SQL
0 vote290 views2 answers
PostgreSQL having
SQL
1 vote295 views1 answer
Mysql not supported auth mode
SQL
0 vote274 views1 answer
How to save data in database in mysql node
SQL
0 vote276 views1 answer
Char varchar nvarchar sql
SQL
0 vote299 views1 answer
View to table sql
SQL
4 votes299 views1 answer
For loop postgresql
SQL