/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 vote392 views1 answer
Sql to excel pgadmin
SQL
0 vote355 views1 answer
Oracle 11g forget password
SQL
0 vote336 views1 answer
Match end of string regex sql
SQL
0 vote350 views1 answer
Change filed order in mysql
SQL
0 vote345 views1 answer
C# mysql update statement set value to null
SQL
16 votes366 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
4 votes341 views1 answer
Oracle error line
SQL
0 vote348 views1 answer
Proc sql not in working
SQL
0 vote338 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
4 votes337 views2 answers
Postgresql reset sequence
SQL