How to write a query in SQL 2005 in order to Select 10 random records from table?

ASHOK PANGULURI

• Feb 11th, 2012

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

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli

• Jan 12th, 2012

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

Answer Question  Select Best Answer