i want to display the srno in my output query,how to do it
eg;if i say "select name,code from emp"

i want some thing like this
no name code
1 abc a01
2 xyz a02

how to do like this,i wish to do this in sql query only ,no proc