Microsoft SQL Server Limit Result Set Limiting With PERCENT


Example

This example limits SELECT result to 15 percentage of total row count.

SELECT TOP 15 PERCENT *
FROM table_name