Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with OrderedPersonel as (
- select row_number() over (order by g.Grade desc) RowNum
- , p.PersonID, p.name, p.family, p.age, g.Grade
- from Personel p(nolock)
- inner join Grade g on p.PersonID=g.PersonID
- ),
- OrderedRates as (
- select row_number() over (order by r.Rate) RowNum, r.rate
- from Rate r(nolock)
- )
- select f.PersonID,f.name,f.family,f.age,g.grade,r.rate
- from OrderedPersonel f
- full outer join OrderedRates r on r.RowNum = f.RowNum
- inner join Grade g
- on g.personid=f.PersonID
- order by r.Rate
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement