TOP with PERCENT in Teradata

You can specify the percentage of recent records that should be returned from a table using TOP with PERCENT.

Syntax:
SELECT TOP n PERCENT * FROM table

n - percentage number

Example:
Consider there are 1000 records present in a table tbl_emp
SELECT TOP 10 PERCENT * FROM tbl_emp

The output will show recent 100 records (10 percent of 1000)