We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Advanced Join
- Placements
- Discussions
Placements
Placements
Sort by
recency
|
1857 Discussions
|
Please Login in order to post a comment
Oracle
SELECT NAME from Students s LEFT JOIN Friends f ON s.ID=f.ID LEFT JOIN Packages p ON f.ID=p.ID LEFT JOIN Packages p1 ON f.Friend_ID=p1.ID WHERE p1.salary>p.salary Order BY p1.salary;
SELECT NAME from Students s LEFT JOIN Friends f ON s.ID=f.ID LEFT JOIN Packages p ON f.ID=p.ID LEFT JOIN Packages p1 ON f.Friend_ID=p1.ID WHERE p1.salary>p.salary Order BY p1.salary;
MySQL select s.name from students s left join friends f on s.id = f.id left join packages p on f.id = p.id left join packages p1 on f.friend_id = p1.id where p1.salary>p.salary order by p1.salary
WITH CTE AS( SELECT S.ID, S.Name, P.Salary,F.Friend_ID FROM Students AS S INNER JOIN Packages AS P ON S.ID=P.ID INNER JOIN Friends AS F ON S.ID=F.ID ) , CTE2 AS( SELECT CTE.Name AS StudentName, CTE.Salary AS StudentSalary, Students.Name AS FriendName, Packages.Salary AS FriendSalary FROM CTE INNER JOIN Students ON CTE.Friend_ID=Students.ID INNER JOIN Packages ON Packages.ID=CTE.Friend_ID ) , CTE3 AS( SELECT CASE WHEN StudentSalary