I'm in a problem during my work. I have to generate serial no.s for each record retrived by a SQL statment with some filter expression specified by a WHERE clause. Can u tell me how can I do it.
Let the query is of the form:
SELECT emp_name, dept_code from emp_tab where dept_code='D1'
please modify the sql such that the output looks like: