Hi all, I have case like this.
200312211750 14.65 0 14.65 14.65 6 200312211800 118.9 119.41 14.65 697.17 200312211810 1324.1 122.6 697.17 1502.3 2 Last field is MODE. That case is at the middle of the database. But these 3 are continues tripel. When MODE='' I need to know all the values of the previous and the next rows. Is there a SQL statement I can use, or do I need to write a code? Regards, Ferhat Is there a way to do that -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
