how can display data same input order

[Unknown Ajanabi]

i enter data in table at this order kamal 78 kamal 78 kamal 78 kamal 45 kamal 45 mohan 12 mohan 12 suresh 23 suresh 23 ram 78 ram 78 mahi 23 mahi 23 and i want to display data on this like [note display according entry] out put name amount timeofpaid kamal 78 3 kamal 45 2 mohan 12 2 suresh 23 2 ram 78 2 mahi 23 2

no knowledge in .net

[Parwej Ahamad]

You can do it with the help of Group By clause and count function.

Parwej Ahamad g.parwez@gmail.com

[Blue_Boy]

select count(amount) as appeartimes,[name] from tablename group by amount,[name]

---

I Love SQL

[Unknown Ajanabi]

Mr blue boy i want to display record in order as entry in table like first time kamal pay 78 amount three time then pay 45 amount two time in table according entry order i want display record kamal 78 3 kamal 45 2 such like that ur quiry never give actual format like entry

no knowledge in .net

[Unknown Ajanabi]

by using group by clause and count function never give correct format according the order of entry in table

no knowledge in .net

[Blue_Boy]

hope this helps select name,count([amount]) as timeofpaid from tablename group by [name],amount order by name,timeofpaid

---

I Love SQL