query like count(name),name,surname

Question

Post reply

query like count(name),name,surname

mayank jarsaniya

Hall of Fame

Points: 3532
More actions
May 19, 2009 at 1:24 am

#131682

I need query like
select count(name),name,surname from info
table info has only three columns
id int,
name varchar,
surname varchar

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Samuel Vella SSCrazy Eights Points: 8055 More actions · Answer 1

select count(*), name, surname

from TableName

group by name, surname

mayank jarsaniya Hall of Fame Points: 3532 More actions · Answer 2

ok.

But I do not need row count i need count(name).

eg.

count(name) name surname

--------------------------------

1 may jar

2 may kar

3 may sar

4 apl ril

5 apl rol

then result should be

count(name) name surname

-----------------------------------

3 may jar

3 may kar

3 may sar

2 apl ril

2 apl rol

matzer SSCrazy Eights Points: 9727 More actions · Answer 3

SELECT

COUNT(*) OVER (PARTITION BY name), name, surname

FROM

Info

Kruti Kansara Hall of Fame Points: 3088 More actions · Answer 4

select name, surname, (select count(*) from Info where name=a.name) as countname

from Info a

"Don't limit your challenges, challenge your limits"

Samuel Vella SSCrazy Eights Points: 8055 More actions · Answer 5

mjarsaniya (5/19/2009)
ok.
But I do not need row count i need count(name).
eg.
count(name) name surname
--------------------------------
1 may jar
2 may kar
3 may sar
4 apl ril
5 apl rol
then result should be
count(name) name surname
-----------------------------------
3 may jar
3 may kar
3 may sar
2 apl ril
2 apl rol

This is why giving example input and output in the original question is a good idea!

Peter has the answer for you

mayank jarsaniya Hall of Fame Points: 3532 More actions · Answer 6

Thanks,

kruti, Peter Brinkhaus

your both's reply works and i get solution thanks............