Select from following answers:- Use select TOP and ORDER BY date DESC
- Use select TOP and GROUP BY date
- Use ROWCOUNT and ORDER BY date DESC
- Use ROWCOUNT and GROUP BY date
- All Above
We should use ORDER BY createdDate DESC to get most recent records and TOP clause to limit the number of records in the result set
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator