How to take count of group by

Question

0.00/5 (No votes)

See more:

Hi
Friends,

I want to take the count of group by

means i was displayed some values group by house no

I want the count of how much group of house no is displayed.

Please Help me........

Thanks in advance....

Posted 5-Nov-13 18:30pm

basurajkumbhar

Add a Solution

4 solutions

Solution 1

Try select count(house_no) from table group by house_no

Posted 5-Nov-13 18:40pm

Abhinav S

Comments

basurajkumbhar 6-Nov-13 0:51am

Thanks for response

Hi i have tried this it gives me group by it works well
SELECT Voter.*, temp100.YadiNo, temp100.CountHouseNo FROM temp100 INNER JOIN Voter ON (temp100.HouseNo = Voter.HouseNo) AND (temp100.YadiNo = Voter.YadiNo) WHERE (((temp100.YadiNo) Between " & txtpartno.Text.Trim & " And " & txtpartno1.Text.Trim & ") AND ((temp100.CountHouseNo) Between " & txtfamilymeb.Text.Trim & " And " & txtfamilymeb1.Text.Trim & "))order by voter.houseno;

I want to how much time group of house no is displayed.
ex

hose no
1
1
1
20
20
30
30
here is three group of house no
it
group of hose no
3

Solution 2

SQL

WITH TempCount(housecount,houseno)
AS
(
    select count(house_no),house_no from table group by house_no
)
SELECT houseno,count(housecount) from TEmpCount

Posted 6-Nov-13 0:59am

coded007

Solution 3

You can put your resulted query in temp table like

select .....into #temp
from
....

group by....

after that use
select COUNT(distinct HouseNO.) from #temp

It will work for you

Posted 6-Nov-13 1:11am

Rahul_Pandit

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

basurajkumbhar · Accepted Answer · 2013-11-06T01:37:00

SELECT Distinct(voter.houseno) FROM temp100 INNER JOIN Voter ON (temp100.HouseNo = Voter.HouseNo) AND (temp100.YadiNo = Voter.YadiNo) WHERE (((temp100.YadiNo) Between " & txtpartno.Text.Trim & " And " & txtpartno1.Text.Trim & ") AND ((temp100.CountHouseNo) Between " & txtfamilymeb.Text.Trim & " And " & txtfamilymeb1.Text.Trim & "))order by voter.houseno;

thanks for all my friends....