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.
  1. Prepare
  2. SQL
  3. Advanced Join
  4. Placements
  5. Discussions

Placements

Sort by

recency

|

1868 Discussions

|

  • namrata_chikhle
     + 0 comments

    shorter and cleaner query:

    SELECT s.name

    FROM friends f

    JOIN students s ON s.id = f.id

    JOIN packages p ON p.id = f.id JOIN packages p2 ON p2.id = f.friend_id

    WHERE p2.salary > p.salary ORDER BY p2.salary;

  • gs06sid
     + 0 comments
    SELECT
    s.name
FROM friends f
JOIN students s ON s.id = f.id
JOIN students s2 ON s2.id = f.friend_id
JOIN packages p ON p.id = f.id
JOIN packages p2 ON p2.id = f.friend_id
WHERE p2.salary > p.salary
ORDER BY p2.salary;

  • obaidshaikh926
     + 0 comments

    the easiest one in all of discussion for mysql- SELECT S.Name FROM Students S JOIN Friends F ON S.ID = F.ID JOIN Packages P1 ON S.ID = P1.ID JOIN Packages P2 ON F.Friend_ID = P2.ID WHERE P2.Salary > P1.Salary ORDER BY P2.Salary;

  • clhunc
     + 0 comments

    SELECT s.Name

    FROM Friends as f LEFT JOIN Students as s ON f.ID = s.ID LEFT JOIN Packages as p ON f.ID = p.ID LEFT JOIN (
    SELECT f.ID, f.Friend_ID, s.Name, p.Salary FROM Friends as f LEFT JOIN Students as s ON f.Friend_ID = s.ID LEFT JOIN Packages as p ON f.Friend_ID = p.ID ) as ff ON f.ID = ff.ID

    WHERE ff.Salary > p.Salary Order by ff.Salary asc

  • 21pa1a04h2
     + 0 comments

    SELECT s.name FROM students s,friends f,packages p1,packages p2 WHERE s.id = f.id and s.id = p1.id and f.friend_id = p2.id and p2.salary > p1.salary ORDER BY p2.salary;