/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 vote205 views1 answer
Mysql update set sum
SQL
0 vote184 views1 answer
Find how many table doesn't contain column in mysql
SQL
2 votes185 views2 answers
Exec procedure pl sql
SQL
6 votes229 views3 answers
Rename column ORACLE
SQL
0 vote207 views2 answers
Add new column after in sql
SQL
25 votes202 views5 answers
Date in mysql
SQL
0 vote194 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote186 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
7 votes200 views1 answer
Xampp reset mysql
SQL
22 votes205 views3 answers
Remove all records from table mysql
SQL