Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
How to limit the results to include only the top 100 most recent records. What is the best way to achieve this?
on 11/20/2013 | Category:
Sql Server Interview questions
| Views: 5058 |
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
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
Many Interviews |
< Previous :
What is the difference between BDC and BCS?
Next > :
CREATE TABLE employee ( id_num int IDENTITY(100,10 ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
CREATE TABLE employee ( id_num int IDENTITY(100,10), fname varchar (20 ...
which one of the following is suitable for writing a new query that wi ...
Which of the following statement is TRUE regarding INSTEAD OF triggers ...
How to generate grand total for the total column as a separate result ...
Which of the following datepart argument is used to get the MINUTE val ...
What is the output of select ISNULL(10, getdate()) as 'IsNullWithD ...
What is the output of select COALESCE(10, getdate()) as 'COALESCE& ...
Which of the following CANNOT be passed back as an output parameter fr ...
Latest Interview Questions
What is Gridview_SelectedIndexChanged and Gridview_RowCommand events i ...
Which Gridview events called first?
In which Gridview Events,We change Label(inside gridview) text or fill ...
What piece of code is missing when navigating to next/previous page in ...
What should be the attribute for a Model property that corresponds to ...
How does Garbage Collector works?
What is the maximum capacity of a DataTable in ADO.NET?