Query Optimization

[sudha swami]

Hi,
Instead of using 2 queries, i would like to use only one to get the output A and B. is there any way to do it.

select description as A
from Area
where status = 0;

select count(id) as B
from Area
where status =1;

regards
sudha

[Muhammad Saifuddin]

SELECT description as A, count(id) as B FROM Area WHERE status <=1;

I didn't try it myself but hope this will work.

[Shailesh Chandra]

Originally posted by Saif uddin:

SELECT description as A, count(id) as B FROM Area WHERE status <=1;

On the first look this query is not going to work because this will also count the ids having status as 0. however the query below is counting only ids which have status 1

select count(id) as B from Area where status =1;

also the query will display the description having status = 1 which is not expected from first query.


Top of all I am not sure what is the requirement to make a single query because first query SELECT DESCRIPTION AS A FROM AREA WHERE STATUS = 0; will result in multiple rows and second query SELECT COUNT(ID) AS B FROM AREA WHERE STATUS =1; will result in one row only.

Thanks,
Shailesh

[Jeanne Boyarsky]

Why do you want to put it in one query?