find dissimilarity of values comparing two adjacent rows (no replies)
(MySQL.com) Hi,
I have a table having 50000 rows, i just want to compare "rec_val" column of each row with 'previuos' and 'next' row of same unique id "rec_id". example:
rec_id - rec_val - rec_date
1001 - 20.00 - 2010-01-01
1001 - 17.00
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-02 00:14:53
