Count of table column

[hgriva]

Hi,
i have a table xx with column flg.

it has values like

flg
----
T
G
T
T
G
G
G
G

I want to write a query that would retrieve
count(flg) where flg='G'
and count(flg) where flg='T'
in a single line query.

[amitpatel66]

Hi,
i have a table xx with column flg.

it has values like

flg
----
T
G
T
T
G
G
G
G

I want to write a query that would retrieve
count(flg) where flg='G'
and count(flg) where flg='T'
in a single line query.

[code=oracle]
SELECT flg,COUNT(flg) from xx GROUP BY flg;

SELECT (SELECT COUNT(flg) from xx WHERE flg = 'G') G, (SELECT COUNT(flg) from xx WHERE flg = 'T') T FROM DUAL;

[/code]

[hgriva]

[code=oracle]
SELECT flg,COUNT(flg) from xx GROUP BY flg;

SELECT (SELECT COUNT(flg) from xx WHERE flg = 'G') G, (SELECT COUNT(flg) from xx WHERE flg = 'T') T FROM DUAL;

[/code]

Hi,
Thanks for your reply.
I need one more clarification.

if want count of flg where flg='G' and count of flg <>'G'
how would i get it

[debasisdas]

Hi,
Thanks for your reply.
I need one more clarification.

if want count of flg where flg='G' and count of flg <>'G'
how would i get it

Also try to use DECODE for the purpose.

[amitpatel66]

Hi,
Thanks for your reply.
I need one more clarification.

if want count of flg where flg='G' and count of flg <>'G'
how would i get it

Give a try to find a count for flg <> G using the ideas from the above post. Post back in case of any issues you face!!

[hgriva]

Thanks.I got the answer

[amitpatel66]

Thanks.I got the answer

We appreciate that!!...