Get count on SQL

Question

How can I do it so that when I run this query.

SELECT distinct cus_areacode AS "Area Code", cus_code AS "Number"
FROM CUSTOMER
WHERE cus_areacode = 713 OR cus_areacode = 615;

instead of showing the following.

Area Code   Number
713         10015
713         10018
615         10019
615         10017
713         10011
615         10010
615         10016
615         10012
615         10014
615         10013

It may show this.

 Area Code  Number
    615       7
    713       3

I tried this

SELECT distinct cus_areacode AS "Area Code", count(cus_code) AS "Number"
FROM CUSTOMER
WHERE cus_areacode = 713 OR cus_areacode = 615;

But it does not work.

Ilesh Patel · Accepted Answer · 2014-04-19 05:37:46Z

2

SELECT cus_areacode AS "Area Code", count(cus_code) AS "Number"
FROM CUSTOMER GROUP BY cus_areacode

answered Apr 19, 2014 at 5:37

Ilesh Patel

2,15516 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bart g Over a year ago

Thank you very much it worked beautifully. I had to add more parts to the query and now every thing worked perfect. Thank you.

Vignesh Kumar A · Accepted Answer · 2014-04-19 06:53:13Z

2

Try this

SELECT cus_areacode AS "Area Code", count(cus_code) AS "Number"
FROM CUSTOMER 
WHERE cus_areacode IN(713,615)
GROUP BY cus_areacode;

OR:

SELECT cus_areacode AS "Area Code", count(cus_code) AS "Number"
FROM CUSTOMER
WHERE cus_areacode = 713 OR cus_areacode = 615
GROUP BY cus_areacode;

Fiddle Demo Here

edited Apr 19, 2014 at 6:53

answered Apr 19, 2014 at 5:39

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

Comments

jmail · Accepted Answer · 2014-04-19 06:51:36Z

1

you need this:

First of all I appreciate to tried query, your going right way, And almost got it you should just remove the distinct and add the Group By your area code.

And they distinct mean its In a table, a column may contain many duplicate values; and sometimes you only want to list the different (distinct) values.

And, The Group by means in a statement is used in conjunction with the aggregate functions to group the result-set by one or more columns.

And you code is following as:

SELECT cus_areacode AS "Area Code", count(cus_code) AS "Number"
FROM CUSTOMER
WHERE cus_areacode = 713 OR cus_areacode = 615
GROUP BY cus_areacode;

SQL FIDDLE

edited Apr 19, 2014 at 6:51

answered Apr 19, 2014 at 6:01

jmail

6,1503 gold badges23 silver badges35 bronze badges

1 Comment

Bart g Over a year ago

Thank you very much jmail. I appreciate your explanation, you seem to know a lot.

SagarPPanchal · Accepted Answer · 2014-04-19 05:41:46Z

0

SELECT areacode,count(cus_code) FROM CUSTOMER GROUP BY areacode

answered Apr 19, 2014 at 5:41

SagarPPanchal

10.2k6 gold badges36 silver badges66 bronze badges

Comments

Ronak Shah · Accepted Answer · 2014-04-19 05:42:33Z

0

try this:

select * from 
(
select cus_areacode , cus_code 
FROM CUSTOMER
WHERE cus_areacode = 713 OR cus_areacode = 615 
) tempalias  
group by cus_areacode

answered Apr 19, 2014 at 5:42

Ronak Shah

1,5592 gold badges13 silver badges20 bronze badges

Comments

Ashish Gaur · Accepted Answer · 2014-04-19 06:49:44Z

0

SELECT cus_areacode AS "Area Code", count(cus_code) AS "Number" FROM CUSTOMER
WHERE cus_areacode = 713 OR cus_areacode = 615
GROUP BY cus_areacode;

edited Apr 19, 2014 at 6:49

answered Apr 19, 2014 at 5:40

Ashish Gaur

2,0403 gold badges20 silver badges34 bronze badges

2 Comments

jmail Over a year ago

Your Query is Wrong its giving some syntax error, you should must change your query,.. But I'm not going to give the (-1) for query,..

Ashish Gaur Over a year ago

Wow thank you for not giving a (-1) I really appreciate it and for so much highlighting text in your comment and answer, you really have all the time in the world but some of us are not so lucky :).

Collectives™ on Stack Overflow

Get count on SQL

6 Answers 6

1 Comment

Comments

SQL FIDDLE

1 Comment

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

1 Comment

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related