/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 vote369 views1 answer
Psql generate id in existing database
SQL
0 vote338 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote358 views1 answer
Why we have to set the password for my sql server
SQL
0 vote333 views1 answer
How to connect to mysql in ef 6
SQL
22 votes348 views4 answers
Mysql reset auto increment id
SQL
0 vote340 views1 answer
Conda install pymysql "windows"
SQL
0 vote333 views1 answer
How to increase the width of the screen in oracle
SQL
4 votes339 views1 answer
Mysql ip address
SQL
0 vote388 views1 answer
SQL Cut part string
SQL
1 vote377 views2 answers
Mysql trim spaces
SQL