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 278 Discussions, By:

votes

  • deepthi_ + 2 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;
    • brac_adnan + 0 comments

      Superb!!! learn a very good pattern from your coding style..

    • nimisha034 + 0 comments

      can u explain this please

  • 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;

  • 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?

  • san28v + 3 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 + 1 comment

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

      • simple_guitar99 + 0 comments

        not really neccesary in this scenario. script could have better performance but no latest records will be retrieve

    • pragmatique + 0 comments

      no lock is superfluous here...only (potentially) useful when tables accessed could be accessed simultaneously by others on the same server.

  • alanxu_80 + 2 comments

    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!

    • arpeethoskote + 0 comments

      That's right.

  • 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.

  • 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;

  • priyankabhakuni1 + 0 comments

    In MYSQL

    SELECT chk.name FROM packages p INNER JOIN ( SELECT s.id, s.name as name, f.friend_id as friend_id, p.salary as my_salary from friends f INNER JOIN students s ON s.id = f.id INNER JOIN packages p ON f.id = p.id
    ) as chk ON chk.friend_id = p.id and chk.my_salary < p.salary order by p.salary;

  • _clfm_ + 0 comments

    MySQL - clean & correct

    Let me know if you have any questions!

    SELECT Name
  FROM Students s
       INNER JOIN Friends f
       ON s.ID = f.ID

       INNER JOIN Packages sp
       ON s.ID = sp.ID

       INNER JOIN Packages fp
       ON f.Friend_ID = fp.ID
 WHERE fp.Salary > sp.Salary
 ORDER BY fp.Salary;

    (From my HackerRank repo on GitHub.)

  • 02jaysenghani + 0 comments

    For 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
Load more conversations