mysql count function

Question

I'm interested in how I can write mysql query if I want to count some column from table (mysql database) where that column must be chosen within another query ? like this SELECT COUNT(OTHER_QUERY) FROM TABLE

I have column named port and want to count this column within another query like this (select port where port='GCP';

I'm trying to do this task but with no result (despite of helping) I'm writing like so => SELECT COUNT(port) from data WHERE port = (select port from data where port='GCP') So I want to count column port which are equal to GCP

please help with this task :)

bhamby · Accepted Answer · 2012-01-03 16:45:46Z

5

Just wrap the original query in a sub-select:

SELECT COUNT(A.column)
FROM (other_query) A

For your second query, I believe this should get what you want:

SELECT COUNT(A.column)
FROM (other_query) A
WHERE A.port='GCP'

edited Jan 3, 2012 at 16:45

answered Jan 3, 2012 at 16:19

bhamby

15.6k1 gold badge49 silver badges67 bronze badges

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

Comments

score 0 · Accepted Answer · 2012-01-03 16:24:28Z

0

It will be like below :

Select (select count(colum_nname) from table2 )  as totalvalues from table

edited Jan 3, 2012 at 16:24

answered Jan 3, 2012 at 16:18

user1119566

Comments

Ritwik · Accepted Answer · 2012-01-04 12:34:44Z

0

Do you want something like this :

Want total number of ports if it's value is GCP.

If so, then this is the syntax:

SELECT COUNT(port) AS alias WHERE port = GCP;

You may find this MySQL COUNT resources useful.

answered Jan 4, 2012 at 12:34

Ritwik

1

Collectives™ on Stack Overflow

mysql count function

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related