[Manohargmr]

--To Print the row number from 1 to 10(or any Number).

select (select count(*)+1 from employee where emp_id <s.emp_id) \'SNO\', * from employee s
ORDER BY emp_id