morethan 3 consecutive rows

[tamilselvan]

Thanks everybody for the response. Can I suggest the DBA team to make the two columns Date and Time into one column as Date? In this way we can sort by Date.

You are right. Then add date col in the order by clause.

OR

Even after you combine those 2 columns, they will not form a unique key. I suggest you should add a running seq col into the table, and make it as PK.

Tamil