Select sno=count(*),a.employee_name
from empmaster a,empmaster b
where a.employee_name >= b.employee_name
group by a.employee_name
order by sno
sno Employee_name
--- -----------------
1 Shidkers
2 Rana
3 Admin
4 AKRAMOL
5 ASAD
6 BABUL
7 FARIDUL ISLAM
8 JAHANGIR
9 JAHID HASAN
10 LITON SHEIKH
11 MAHFUZ
Ref: http://support.microsoft.com/kb/186133
কোন মন্তব্য নেই:
একটি মন্তব্য পোস্ট করুন