Calculate the time difference between of two rows

by

To achieve what you are asking try the following (UPDATE after edit from OP):

SELECT A.requestid, A.starttime, (B.starttime - A.starttime) AS timedifference
FROM MyTable A INNER JOIN MyTable B ON B.requestid = (A.requestid + 1)
ORDER BY A.requestid ASC

IF requestid is not consecutive then you can use

SELECT A.requestid, A.starttime, (B.starttime - A.starttime) AS timedifference
FROM MyTable A CROSS JOIN MyTable B
WHERE B.requestid IN (SELECT MIN (C.requestid) FROM MyTable C WHERE C.requestid > A.requestid)
ORDER BY A.requestid ASC

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. MySQL select 10 random rows from 600K rows fast
  3. How do you use the “WITH” clause in MySQL?
  4. How to change max_allowed_packet size
  5. Simulate lag function in MySQL
  6. mysql error 1364 Field doesn’t have a default values
  7. SQL: What is the default Order By of queries?
  8. MySQL Split Comma Separated String Into Temp Table
  9. Can I use a function for a default value in MySql?
  10. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  11. Get record counts for all tables in MySQL database
  12. Query to get all rows from previous month
  13. How do I check if a column is empty or null in MySQL?
  14. Use MySQL spatial extensions to select points inside circle
  15. MySQL versus PDO [duplicate]
  16. Mysql string split [duplicate]
  17. Increment a database field by 1
  18. Measuring actual MySQL query time
  19. Am I Using JDBC Connection Pooling?
  20. MySQL VARCHAR Lengths and UTF-8
  21. mysql transaction – roll back on any exception
  22. Deleting duplicate rows from a table
  23. Modeling Product Variants
  24. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  25. MySQL LIKE query with underscore
  26. How do I refer to capture groups in a MySQL regex?
  27. Pass parameter to MySQL script command line
  28. What is the default MySQL JOIN behaviour, INNER or OUTER?
  29. How to get the mysql table columns data type?
  30. Mysql stored procedure don’t take table name as parameter

Leave a Comment