/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 vote251 views1 answer
Sql query for getting data with join and count
SQL
0 vote270 views1 answer
Mysql make date from 2 column
SQL
0 vote289 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
16 votes268 views1 answer
Sql comment'
SQL
1 vote222 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
1 vote274 views1 answer
Mysql how to truncate table with foreign keys
SQL
0 vote254 views1 answer
2020 new year
SQL
2 votes279 views1 answer
Oracle sql merge
SQL
19 votes296 views5 answers
Display table in sql
SQL
0 vote268 views4 answers
Convert databse to achieve log mode oracle
SQL