Could you please help me. I have one huge table which has this two columns.
I do need to list same records (cols_id) which they are appear for two or more days in a row. So to be more clear if i have table which has records for last 5 years, and i need to list all same hr_coil_id records which are repeating for 2 or more days in a row.