/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 vote320 views3 answers
Osx stop mysql service
SQL
2 votes319 views2 answers
Sql first character
SQL
3 votes313 views2 answers
Brew start mysql
SQL
0 vote320 views1 answer
Sql comand for removing data from table
SQL
1 vote342 views1 answer
Mamp mysql path mac
SQL
0 vote293 views1 answer
Get all employees if name ends with in sql
SQL
0 vote320 views1 answer
QUERY JPQL
SQL
0 vote321 views2 answers
Sqlalchemy core in clause
SQL
1 vote320 views1 answer
Select 2 rows in sql
SQL
0 vote305 views1 answer
T-sql check if data exists
SQL