/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 vote145 views1 answer
Psql check if value in array
SQL
0 vote137 views1 answer
Duplicate foreign key constraint name
SQL
0 vote208 views1 answer
Updating database in sql
SQL
1 vote169 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote153 views1 answer
Drop all tables db2
SQL
0 vote143 views1 answer
Zerar auto increment mysql
SQL
1 vote141 views1 answer
Select from one table where not on the other
SQL
8 votes148 views3 answers
Alter table auto_increment
SQL
0 vote147 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote210 views1 answer
Fetching data from mysqldb
SQL