Hi All,
my oracle version is 11.2.0.2
Sample data
Table Name - t_applicant
| sz_customer_no | i_applicant_id | sz_tranzware_cust_no |
| 3263 | 1 | NULL |
| 3263 | 2 | NULL |
| 3264 | 3 | NULL |
| 3265 | 4 | NULL |
| 3266 | 5 | NULL |
| 3267 | 6 | NULL |
| 3267 | 7 | NULL |
| NULL | 8 | NULL |
| NULL | 9 | NULL |
From the above table i need query which fetches records with unique customer id and the result should contain all the null values.
Here is a query which i created which fetches only one null value of the sz_customer_id column not all the null values of the sz_customer_id column.
select min(apt.i_applicant_id) i_applicant_id, apt.sz_customer_no
from wf_t_notifications t, t_applicant apt
where apt.sz_tranzwar_customer_no is null
group by apt.sz_customer_no;
My requirement is to fetch all the null values of sz_customer_no column with unique sz_customer_no(all null values should be present in result).