Limit rows

Database
Enthusiast

Limit rows

I want to select only 10 rows from table. How to limit rows in Teradata?

eg select * from T1. I want to select only 10 rows from T1 where table 'T1' has 100000 rows.
2 REPLIES
Enthusiast

Re: Limit rows

select *
from table_T1
sample 10

Enthusiast

Re: Limit rows

select top 10 * from table_t1

will give you same result and let you order

select top 10 * from table_t1 order by 1 desc