Forum Discussion
Filtering repetetive rows in an sql database
Hi all, I have one dataset with column names- "tool no", "wear offset" , "tool length", "tool life" , "time stamp". In this dataset rows are coming per second. There are different tool nos who have...
j_ocean
Helper V
Helper VGroup by all columns except time stamp, aggregate by min time stamp. So if you get readings like
a 0.3
b 0.3
c 0.2
d 0.2
e 0.3
You'll retain rows a c and e, which are the time stamps when the value changed.