답변감사합니다
다시 질문이 있는데요
SELECT A.*, RANK() OVER (PARTITION BY ETSI_PROJECTS,COMPANIES,APPLICATION_NUMBER,DECLARATIONS,IPR_DISCLOSURES ORDER BY standards desc) as rk from( SELECT '-' AS ETSI_PROJECTS, 'None' as standards, 'andrew' AS COMPANIES, '62194140' AS APPLICATION_NUMBER, 'ISLD-201603-003' AS DECLARATIONS, 'Disclosure number 1' AS IPR_DISCLOSURES FROM DUAL UNION SELECT '-', 'None', 'andrew', '62194141', 'ISLD-201603-003','Disclosure number 2' FROM DUAL UNION SELECT '-', 'ts101548 v1.3.1', 'andrew', '62194140', 'ISLD-201603-003','Disclosure number 1' FROM DUAL UNION SELECT '-', 'ts101548 v1.3.1', 'andrew', '62194141', 'ISLD-201603-003','Disclosure number 2' FROM DUAL UNION SELECT 'None', '2.45', 'alcatel', '903.12.0970', 'ISLD-201006-001','Disclosure number 1' FROM DUAL UNION SELECT 'None', 'None', 'alcatel', '903.12.0970', 'ISLD-201006-001','Disclosure number 1' FROM DUAL )A
첫줄에 말씀하신게 이렇게 하는게 맞나요??
다른 값은 다 같으니 order by를 starands에 해야하는데 이러면 standards가 None인게 rk가 1이 될수도있어서요...
아 위에서 말했던 D컬럼이 standards컬럼입니다