Home > database >  SQL: time difference data within 5 minutes, take a 1
SQL: time difference data within 5 minutes, take a 1

Time:11-28

Think sorted according to time, time in 5 minutes before and after is duplicate data, these data only take a record, how to write a SQL query?

SQL: hive, oracle

  • Related