/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 vote301 views1 answer
Mysql grant access to one database
SQL
0 vote196 views1 answer
Set default value now() date
SQL
5 votes154 views1 answer
Mongodb vs
SQL
0 vote194 views1 answer
Sql server remove enter from string
SQL
0 vote208 views1 answer
Get record which is available in one table but not in another mysql
SQL
1 vote419 views1 answer
How to make a select in sql
SQL
7 votes240 views1 answer
Query delete duplicates
SQL
8 votes201 views2 answers
Safe update mode in mysql
SQL
1 vote219 views2 answers
Mysql does sentance contain word
SQL
2 votes197 views1 answer
Mysql last 7 days including today
SQL