chetana bhargav
<bhargav_chetana-/[EMAIL PROTECTED]> wrote:
Actually I am trying to retrieve values in a single step.
My queries need to be something like,
select count(*) from tbl1 where state='Normal';select count(*) from
tbl1 where state='Critical'
Why not
select state, count(*)
where state in ('Normal', 'Critical')
group by state;
?
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
