Quiz: ORDER BY

Quiz: ORDER BY

  • SELECT PersonID
    FROM Application.People;
  • SELECT PersonID,
         FullName
    FROM Application.People
    ORDER BY 1 ASC;
  • SELECT FullName
    FROM Application.People
         OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY;
  • SELECT FullName
    FROM Application.People
    ORDER BY PersonID
        OFFSET 10 ROWS;

Want to learn more about ORDER BY?

Check out this post to get the scoop on how everyone did, plus notes on the answers.