Advertisement
Guest User

Untitled

a guest
Aug 30th, 2016
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. with OrderedPersonel as (
  2. select row_number() over (order by g.Grade desc) RowNum
  3. , p.PersonID, p.name, p.family, p.age, g.Grade
  4. from Personel p(nolock)
  5. inner join Grade g on p.PersonID=g.PersonID
  6. ),
  7. OrderedRates as (
  8. select row_number() over (order by r.Rate) RowNum, r.rate
  9. from Rate r(nolock)
  10. )
  11. select f.PersonID,f.name,f.family,f.age,g.grade,r.rate
  12. from OrderedPersonel f
  13. full outer join OrderedRates r on r.RowNum = f.RowNum
  14.  
  15. inner join Grade g
  16. on g.personid=f.PersonID
  17. order by r.Rate
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement