You're designing a new query that will return all of the medical records from the patients table. This could run into millions of rows so you need to find a way to limit the results to include only the top 100 most recent records. What is the best way to achieve this?

 Posted by Bandi on 7/30/2014 | Category: Sql Server Interview questions | Views: 1567 | Points: 40
Select from following answers:
  1. Use select TOP and ORDER BY date
  2. Use select TOP and GROUP BY date
  3. Use ROWCOUNT and ORDER BY date
  4. Use ROWCOUNT and GROUP BY date
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response