get count from sql query result

Question

I have such query

SELECT `id`
FROM (`TABLE`)
WHERE date(FROM_UNIXTIME(time)) >= '2013-10-28'
GROUP BY `last`
ORDER BY `id_s` DESC

the result is:

| id |

9
1
1
9
50
3
1

My question is how to count how many times repeating number 9 in result?

So, the final result must be one row with number 2

Somebody have idea how possible to do it?

Please provide information about the table structure and some example data. — wolfgangwalther
– wolfgangwalther, Commented Oct 29, 2014 at 10:22

wolfgangwalther · Accepted Answer · 2014-10-29 10:27:45Z

1

You could just use the result set that you already have, select id=9 from it and count the rows:

SELECT COUNT(*)
FROM (
  --your current query here
) WHERE `id`=9
GROUP BY `id`

There might be a better way of doing this in your situation, but without knowing your table structure and maybe seeing some example data, this is hard to tell.

answered Oct 29, 2014 at 10:27

wolfgangwalther

1,2367 silver badges15 bronze badges

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

Comments

Gordon Linoff · Accepted Answer · 2014-10-28 16:18:59Z

1

You would use count(*):

SELECT count(distinct last)
FROM (TABLE)
WHERE date(FROM_UNIXTIME(time)) >= '2013-10-28' AND
      id = 9 ;

I'm not sure what the group by really does, so it might be sufficient to do:

SELECT count(*)
FROM (TABLE)
WHERE date(FROM_UNIXTIME(time)) >= '2013-10-28' AND
      id = 9 ;

answered Oct 28, 2014 at 16:18

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

3 Comments

stefek143 Over a year ago

Unfortunatly will not work becouse key in this query is "ORDER BY id_s"

stefek143 Over a year ago

The best way will if is possible to get this 9 after executed this query?

Gordon Linoff Over a year ago

I am totally missing something. The order by has nothing to do with how many times the value "9" appears.

Collectives™ on Stack Overflow

get count from sql query result

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related