/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 vote150 views1 answer
Php select data from mysql database without column name
SQL
1 vote376 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
1 vote190 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote143 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote143 views1 answer
Duplix print in Smartforms
SQL
0 vote149 views1 answer
Sql query to return field name of a table
SQL
0 vote121 views1 answer
Truncate table sql server foreign key
SQL
0 vote164 views1 answer
Mysql loop through databases and execute query
SQL
0 vote126 views1 answer
Mysql add to value
SQL
0 vote144 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL