/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

3 votes98 views1 answer
How to remove characters from string in mysql
SQL
1 vote110 views1 answer
Rermove categories woocommerce sql
SQL
16 votes128 views1 answer
Sql comment'
SQL
0 vote66 views1 answer
Create duplicate table postgres
SQL
3 votes107 views1 answer
How to find names includes in sql
SQL
1 vote100 views1 answer
Oracle list data files
SQL
2 votes111 views2 answers
Postgresql get table names
SQL
0 vote118 views1 answer
Sql bild in function
SQL
0 vote106 views1 answer
How get data from database if id not found then search another column
SQL
2 votes92 views1 answer
Can you use a where clause for a child query
SQL