vinoth.jeevanandam

 Profile Answers by vinoth.jeevanandam 

• Mar 3rd, 2009

 

select * from table_name sample(10);

my_azam

 Profile Answers by my_azam 

• Jun 8th, 2009

 

select top 10 * from tablename orderby newid()

smonroy

 Profile Answers by smonroy 

• Sep 26th, 2011

 

SELECT TOP 10 * FROM TABLE_NAME ORDER BY NEWID()
EXAMPLE:
select top 10 * from cars order by newid()
ID CAR DESCRIPTION
504 CARRO 77 CARRO DE CHASIS
501 CARRO 74 CARRO DE CHASIS
46 CARRO 45 CARRO 45
526 CARRO 99 CARRO DE CHASIS
37 CARRO 36 CARRO 36
498 CARRO 70 CARRO DE CHASIS
40 CARRO 39 CARRO 39
44 CARRO 43 CARRO 43
473 RACK 160 RACK 160
24 CARRO 23 CARRO 23

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli 

• Jan 12th, 2012

 

Code
SELECT * FROM emp WHERE rownum<=10 ORDER BY e_id;

ASHOK PANGULURI

• Feb 11th, 2012

 

Code
SELECT * FROM emp WHERE rownum>=10 ORDER BY empno;