ansaurus

Question

Answer 1

+1 A:

select yn, count(*)
from stats
group by yn;

ar 2010-03-02 14:02:56

i dont have the yn field, i have only one field name is recommend tbl name is stats...

Bharanikumar 2010-03-02 14:08:14

i tried somthing like this "SELECT count(recommend) FROM ".TBLRESULT." group by recommend ";

Bharanikumar 2010-03-02 14:09:09

As you didn't bother to tell us what columns were in your table, I made up a column name.

ar 2010-03-02 14:14:33

@Bharanikumar I'm downvoting your question as you failed to give the necessary information.

PP 2010-03-02 14:22:46

Answer 2

+1 A:

Try something like this

SELECT  SUM(CASE WHEN recommend = 'Y' THEN 1 ELSE 0 END) YesCount,
        SUM(CASE WHEN recommend = 'N' THEN 1 ELSE 0 END) NoCount,
        COUNT(*) TotalCount
FROM    Stats

astander 2010-03-02 14:07:09

This what i asked..problem fixed

Bharanikumar 2010-03-02 14:12:29

Bharanikumar: Please mark his response as the correct one... it's the empty thingy below the the point counter.

Helgi Hrafn Gunnarsson 2010-03-02 14:16:41

ansaurus

tags:

views:

answers:

MySQL find count query

related questions