/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

12 votes129 views2 answers
Select into insert sql server
SQL
1 vote122 views1 answer
Describe table in sql
SQL
3 votes110 views1 answer
Oracle user quota unlimited
SQL
2 votes151 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote127 views1 answer
Postgres clear table
SQL
0 vote75 views1 answer
Mysql collation for all languages
SQL
3 votes117 views1 answer
APEX elapsed time
SQL
0 vote123 views2 answers
Search stored procedures by name
SQL
2 votes132 views1 answer
Where clause for child record apex
SQL
5 votes121 views1 answer
Ascending order and where in sql
SQL