/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 vote118 views1 answer
Alter table change default
SQL
2 votes99 views1 answer
Sqlite3 show columns name
SQL
0 vote124 views1 answer
Limit in access query
SQL
16 votes129 views1 answer
Mysql smallint range
SQL
1 vote110 views3 answers
What is union in sql
SQL
0 vote123 views1 answer
Psql check table fields
SQL
3 votes107 views1 answer
Laravel database Using Named Bindings
SQL
0 vote110 views1 answer
Oracle procedure chain step
SQL
1 vote102 views1 answer
Mysql drop key
SQL
0 vote111 views1 answer
Get duplicate entry sql
SQL