percentage records table

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
F

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
 
Frank Dulk said:
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;
 
Back
Top