I have many records in db.
id name key
1 ali 10
2 amir 2
3 reza 5
4 ali 1
5 amir 25
6 amir 7
i want this query back
name keycount
ali 2
amir 3
reza 1
What to write query?
select name,count(keycount) from tablename
group by name
© COPYRIGHT 2024 ASPSnippets.com ALL RIGHTS RESERVED.