How do you retrieve a sample of 'n' rows in random without any filterting (where) conditions?

xyz

• Aug 13th, 2007

 

We write the query as follows:

SELECT * from table_name
fetch first n rows only

where n is an integer value.

sumit_tumba

 Profile Answers by sumit_tumba 

• Jan 16th, 2008

 

select * from table_name sample n

n:1,2...100..
that is used in Teradata....