Hi,
Please help me to retrieve the Non nullable data for each column based on the vendor_rank column, Partitioned by Pricing num.
Refer the attached screenshot:
Sample script:
CREATE TABLE TEST_RANK
(PRICING_NUMBER NUMBER(9),
NAME VARCHAR(30),
LAST_NAME VARCHAR(30),
DEPT VARCHAR(30),
RANK NUMBER(3));
INSERT INTO TEST_RANK SELECT 91, 'State bank',NULL,NULL,1 FROM DUAL;
INSERT INTO TEST_RANK SELECT 91, 'State bank',NULL,'BANK',2 FROM DUAL;
INSERT INTO TEST_RANK SELECT 91, 'State bank of TN','Ind','BANKs',3 FROM DUAL;
INSERT INTO TEST_RANK SELECT 92, 'HDFC',NULL,'Curr',1 FROM DUAL;
INSERT INTO TEST_RANK SELECT 92, NULL,'HDFC bank','Curr',2 FROM DUAL;
INSERT INTO TEST_RANK SELECT 93, 'Citi','Bank','Bank',1 FROM DUAL;
insert into TEST_RANK SELECT 94, 'YEs','Bank',NULL,1 FROM DUAL;
SELECT * FROM TEST_RANK;