KB-28682: Retrieving a limited amount of data in the Query.

Question:

How can I set up a Query to display the last 15 records?

Solution:

To do so, you must enable SQL direct edition, and use SQL’s TOP command set with the number of values that will return (in this case, 15).

Example:

SELECT TOP 15 VariableName
FROM TableName

Print Friendly, PDF & Email

Este artigo foi útil? Was this helpful?

Classificação média - Average rating 0 / 5. Count: 0

Leave a Reply

Your email address will not be published.Required fields are marked *