/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
Difference between db.query and db.execute
SQL
0 vote129 views2 answers
Mysql password error create datbase
SQL
7 votes154 views2 answers
Postgres concat
SQL
0 vote126 views1 answer
Change default schema sql server
SQL
0 vote127 views1 answer
Get all employee of salary if more than in sql
SQL
12 votes136 views2 answers
Insert multiple rows from another table sql
SQL
6 votes148 views4 answers
Mysql group by month
SQL
0 vote144 views1 answer
Select place default lat long
SQL
1 vote171 views1 answer
Mysql default port
SQL
0 vote128 views1 answer
Order by ip address sql
SQL