Code: SELECT * FROM test WHERE ROWNUM <= ( SELECT CEIL(COUNT(1)*10/100) FROM test ) HTH Sameer
SELECT * FROM test WHERE ROWNUM <= ( SELECT CEIL(COUNT(1)*10/100) FROM test )
Forum Rules