/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 vote222 views1 answer
Create domain sql
SQL
5 votes224 views2 answers
Oracle to_timestamp
SQL
0 vote229 views1 answer
Order by number of character in sql
SQL
1 vote232 views1 answer
Add current timestamp in mysql
SQL
2 votes295 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
1 vote226 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote285 views1 answer
Mysql concatenate select results
SQL
1 vote222 views4 answers
Fatal database postgres does not exist
SQL
0 vote228 views1 answer
If null don't update
SQL
0 vote230 views1 answer
How to populate a table in MySQL from and existing csv file
SQL