getting count values in mysql

Question

I have a table with 3 columns and looks like

branchid  semesterid  courseid
 4          25           2        
 4          36           5
 4          23           3
 4          12           10 
 4          34           15
 4          2            7
 4          23           42

 7          23           9
 7          10           6
 7          34           3
 7          20           17

I need the count of semesterid and courseid of that branch

SELECT branchid, count(semesterid), count(courseid) WHERE branchid = 4

When I execute this query, the count(semesterid) shows wrong count and courseid shows correct count of 7

what is the value semesterid shows?

karthikr
– karthikr

2012-09-13 13:40:20 +00:00
Commented Sep 13, 2012 at 13:40 — karthikr
– karthikr, Commented Sep 13, 2012 at 13:40

raina77ow · Accepted Answer · 2012-09-13 13:41:47Z

1

With my crystal ball I predict you need this instead:

SELECT COUNT(DISTINCT semesterid), 
       COUNT(DISTINCT courseid) 
  FROM Table1 
 WHERE branchid = 4;

... as the query shown should work just fine for counting the number of records (but not unique records).

answered Sep 13, 2012 at 13:41

raina77ow

107k16 gold badges205 silver badges240 bronze badges

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

Comments

Joe G Joseph · Accepted Answer · 2012-09-13 13:41:49Z

0

try:

SELECT branchid, 
       count(distinct semesterid) as semesterid, 
       count(distinct courseid) as courseid
FROM   <table>
WHERE  branchid = 4
group by branchid

answered Sep 13, 2012 at 13:41

Joe G Joseph

24.2k5 gold badges58 silver badges58 bronze badges

Comments

phlogratos · Accepted Answer · 2012-09-13 13:43:46Z

0

If you want the number of unique results you have to replace count(id) with count(distinct id)

answered Sep 13, 2012 at 13:43

phlogratos

14k1 gold badge35 silver badges38 bronze badges

Collectives™ on Stack Overflow

getting count values in mysql

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related