Select Only the Oldest Duplicate Record

You could be having more columns than required
Thats when this happens

Example
select col1 , max() from
if its
select col1 ,col2 , col3 , max() from ..this will return a lot more rows

1 Like