/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 vote152 views1 answer
Duplicate foreign key constraint name
SQL
0 vote158 views1 answer
Postgresql array to rows
SQL
1 vote163 views1 answer
Mysql return text after a final full stop
SQL
1 vote166 views1 answer
Truncate left characters mysql
SQL
9 votes163 views2 answers
Oracle all tables in schema
SQL
4 votes175 views1 answer
Postgresql list sequences
SQL
0 vote344 views1 answer
How to connect .sql data set to powerbi
SQL
50 votes195 views6 answers
Install mysql on ubuntu
SQL
2 votes182 views2 answers
Mysql add hours to time field
SQL
1 vote181 views1 answer
Database Queries
SQL