Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
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?
on 7/30/2014 | Category:
Sql Server Interview questions
| Views: 669 |
Select from following answers:
Use select TOP and ORDER BY date
Use select TOP and GROUP BY date
Use ROWCOUNT and ORDER BY date
Use ROWCOUNT and GROUP BY date
SELECT TOP n and ORDER BY clauses are used to retrieve recent records
Show Correct Answer
Many Interviews |
< Previous :
You need to write a new query that will return nam ...
Next > :
What is wrong with the T-SQL batch statement below ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
What is wrong with the T-SQL batch statement below: @find varchar(3 ...
SQL Server 2012 uses the standard four-part naming convention when ref ...
You're creating a new query that will select rows from a products ...
You need to delete a stored procedure from the SQL Server 2012 databas ...
Your manager has asked you to check the index stats for a particular t ...
Which of the following CANNOT be passed back as an output parameter fr ...
Which of the following generates control-breaks and subtotals in the r ...
You've created a simple select statement that returns the customer ...
Latest Interview Questions
By default,Asp.Net stores SessionIDs in which mechanism?
In order to prevent a browser from caching a page which of the stateme ...
We have defined one page_load event in aspx page and the same is defin ...
How to display a computer code in html
What is the FEATURES or PURPOSE of Raise Error?
Can a Clustered Index ALSO be a Unique Index?
Which statement is used for defining a Cursor?
Which Process is used for Maintaining State Server Session in Asp.Net ...