I'm writing some code but there are some errors. If the numbers are the same, to show only one record of the oldest date. Thanks for help.
The errors: SQL command not properly ended and not a single-group group function
My code in the following
select DIVISION, DEPT_CODE, NO, min(START_DATE), row_number() over (order by DIVISION, DEPT_CODE ) as "NEW_NO" FROM INFO Group by NO where (TITLE IS NULL OR (upper(TITLE) NOT LIKE '%RESEARCH%' AND upper(TITLE) NOT LIKE '%POSTDOCTORAL FELLOW%' AND upper(TITLE) NOT LIKE '%PROJECT%' ) )