percentage records table

[Frank Dulk]

Is it possible to limit the amount of records of a query not for amount, but
for percentage?
10% of 50 records of the table = 5

 

[Dirk Goldgar]

Is it possible to limit the amount of records of a query not for
amount, but for percentage?
10% of 50 records of the table = 5

SELECT TOP 10 PERCENT * FROM MyTable;