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

Placements

Sort 253 Discussions, By:

votes

  • deepthi_ + 0 comments
    Select S.Name
From ( Students S join Friends F Using(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;

  • san28v + 2 comments

    My simple solution using SQL Server:

    SELECT S.Name
FROM Students S WITH (NOLOCK)
INNER JOIN Friends F WITH (NOLOCK) ON S.ID = F.ID
INNER JOIN Packages P WITH (NOLOCK) ON P.ID = S.ID
INNER JOIN Packages PF WITH (NOLOCK) ON PF.ID = F.Friend_ID AND P.Salary < PF.Salary
ORDER BY PF.Salary
    • nam097 + 0 comments
      [deleted]
    • christya_dantji1 + 0 comments

      what is the purpose of 'WITH (NOLOCK)'?

  • mithunstany + 1 comment

    MS SQL Server

    WITH CTE AS( select s.id,s.name,f.friend_id,p.salary as salary, q.salary as friendssalary from students s INNER JOIN Friends f ON s.id=f.id INNER JOIN packages p ON s.id=p.id INNER JOIN packages q ON f.friend_id=q.id
    ) select name from CTE where friendssalary>salary order by friendssalary

    • fghbergman + 0 comments

      Using a CTE is actually unnecessary, isn't it?

  • carrielstylem + 1 comment

    simple in mysql, use alias:

    select s.name from students s inner join friends f on s.id=f.id inner join packages p on p.id=s.id inner join packages p1 on p1.id=f.friend_id where (p1.salary-p.salary)>0 order by p1.salary;

    • andyang94 + 0 comments

      Good solution, MINE LOOKS MORE length with sub queries.. SELECT s1.name FROM (SELECT s.id, s.name, p.salary FROM students s JOIN packages p ON s.id = p.id) s1 JOIN (SELECT f.id , f.friend_id, p.salary FROM friends f JOIN packages p ON f.friend_id = p.id) f1 ON s1.id = f1.id WHERE s1.salary < f1.salary ORDER BY f1.salary;

  • kera404 + 1 comment

    In MySql

    (select A.name from
    (select a.id id, a.name name, p.salary salary, f.friend_id fid from Students a 
    join friends f on f.id=a.id
    join packages p on p.id=a.id) A
join students b on b.id=A.fid
join packages pp on pp.id=A.fid
where A.salary<pp.salary
order by pp.salary)
    • Ciado + 0 comments

      '..join students b on b.id=A.fid' is redundant.

  • alanxu_80 + 1 comment

    Oracle solution:

    select s.name from students s, friends f, packages p, packages p2 where s.id = f.id and f.friend_id = p2.id and s.id = p.id and p.salary < p2.salary order by p2.salary;

    • einmannmitdemlo1 + 0 comments

      Neat!

  • BhanuBharadwaja + 1 comment

    In MS SQL

    with t as (select stu.id as ID, stu.name as Name , pak.salary as Salary , frnd.friend_id as FriendId from students as stu , friends as frnd , packages as pak where stu.id = pak.id and frnd.id = pak.id ),

    s as ( select t1.ID as tid , t1.Name as Names , t1.Salary as firstsal , t1.FriendId , t2.Salary as secondsal from t as t1 , t as t2 where t1.FriendId = t2.ID )

    select Names from s where firstsal < secondsal order by secondsal;

    • manojsusarla96 + 1 comment

      Very Nice solution and very helpful

      • khajuria_ankush + 0 comments

        with first as (select a.id as id,a.name as name ,b.friend_id as friend_id , c.salary as salary from students a inner join friends b on a.id=b.id inner join packages c on b.id=c.id), friend as (select f.friend_id as friend_id,p.salary as friend_salary from friends f inner join packages p on f.friend_id=p.id) select f.name from first f inner join friend d on f.friend_id=d.friend_id where d.friend_salary > f.salary order by d.friend_salary asc;

  • Hacker_RK + 0 comments

    Solution of the given problem in Microsoft Sql Server by Rayedox Technologies :

    select students.name from friends a inner join students on a.id=students.id

inner join packages on a.friend_id=packages.id 

where packages.salary>(select salary from friends inner join packages on packages.id=friends.id  where friends.id=a.id)

order by packages.salary

    Please visit www.rayedox.com for futher queries or mail us at support@rayedox.com or rayedox@gmail.com

  • Indhujayaraj + 0 comments

    select b.name from packages a, students b, friends c, packages d where a.id=b.id and a.id=c.id and d.id = c.friend_id and (d.salary-a.salary) > 0 order by d.salary;

  • sanjaybishnoi139 + 0 comments

    Can anyone please tell me why my solution is not working?

    SELECT Students.Name FROM Students JOIN Packages ON Students.ID = Packages.ID WHERE (SELECT Salary FROM Packages Where Packages.ID = Students.ID ) < (SELECT Salary FROM Packages JOIN Friends ON Packages.ID = Friends.ID Where Packages.ID = Friends.Friend_ID) ORDER BY (SELECT Salary FROM Packages JOIN Friends ON Packages.ID = Friends.ID Where Packages.ID = Friends.Friend_ID) DESC;

Load more conversations