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

Quote:

Originally Posted by 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.

Expand|Select|Wrap|Line Numbers

 
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;

hgriva

Quote:

Originally Posted by amitpatel66

Expand|Select|Wrap|Line Numbers

 
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;

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

Quote:

Originally Posted by hgriva

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

Quote:

Originally Posted by hgriva

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

Quote:

Originally Posted by hgriva

Thanks.I got the answer

We appreciate that!!...

Count of table column

re: Count of table column

re: Count of table column

re: Count of table column

re: Count of table column

re: Count of table column

re: Count of table column

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about