Hi
I have a simple report with two column. The query is as below.
SELECT decode(caste,1,'SC/ST',2,'General','3','PWD') fcastepi,
nvl(count(*),0) fcapi
FROM applicationformdtl
WHERE year = _year
AND selected = 1
AND PROGCD = 'PRM'
GROUP BY caste

This query returns values for SC/ST and General as there is no
matching data for the PWD. But I want to display PWD with value 0 in
the report. How to do this? Can anyone help me in this matter at the
earliest?

The required output is
SC/ST 100
General 300
PWD 0

Regards
Trusha

<dtrusha (AT) gmail (DOT) com> a écrit dans le message de news: 1173420147.016604.284770 (AT) p10g20...oglegroups.com...
Something like:

SELECT decode(b.caste,1,'SC/ST',2,'General','3','PWD') fcastepi,
nvl(count(a.caste),0) fcapi
FROM applicationformdtl a
, ( select rownum caste from dual connect by level <= 3 ) b
WHERE year (+) = _year
AND selected (+) = 1
AND PROGCD (+) = 'PRM'
and a.caste (+) = b.caste
GROUP BY b.caste
/

Regards
Michel Cadot