//*// Select serial number with a list of columns //*//

select
(select count(*) from emp where empname <= n.empname) as SRNo,
empname from emp n
order by empname