Count of table column [message #293248] |
Fri, 11 January 2008 06:21  |
hgriva
Messages: 17 Registered: December 2007
|
Junior Member |
|
|
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.
|
|
|
|
Re: Count of table column [message #293250 is a reply to message #293249] |
Fri, 11 January 2008 06:49   |
hgriva
Messages: 17 Registered: December 2007
|
Junior Member |
|
|
Hi,
Thanks for your reply.
I need one more clarification.
if want count of flg where flg='G' and count of flg <>'G'in single query,how would i get it
|
|
|
|
|
|
|
|