Wednesday, March 7, 2012

define number of rows returned from query

Is there a way to limit the number of rows returned from a reporting services query?

as in my query will return 500 rows but i only want the 1st 5 rows.

right after the select you would use "TOP 5". So it would look something like

select top 5 * from table_name

No comments:

Post a Comment