/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 vote158 views1 answer
Where in clause tsql
SQL
9 votes152 views1 answer
Sql server get utc date
SQL
0 vote166 views2 answers
Temp Space
SQL
0 vote209 views1 answer
Mysql remove last character
SQL
8 votes187 views2 answers
Sqlsrv default port
SQL
0 vote183 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote161 views1 answer
Pl sql join 3 tables
SQL
0 vote160 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
12 votes168 views5 answers
Sql primary key
SQL
0 vote233 views1 answer
Shortcut run sql pgadmin
SQL