/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

1 vote112 views1 answer
Sql update table remove spaces
SQL
0 vote116 views1 answer
Search db for table name
SQL
27 votes130 views6 answers
Sql update record
SQL
1 vote120 views3 answers
Mysql parse int
SQL
3 votes126 views3 answers
Mysql declare variable
SQL
1 vote110 views1 answer
Sql not equal multiple columns
SQL
0 vote139 views1 answer
Sql tablo sp
SQL
0 vote109 views1 answer
How to define a save method in ruby for sql databases
SQL
23 votes84 views3 answers
Mysqldump
SQL
0 vote115 views1 answer
Product of a column in mysql
SQL