MySql – How get value in previous row and value in next row? [duplicate]

by

Select the next row below:

SELECT * FROM Example WHERE id < 3 ORDER BY id DESC LIMIT 1

Select the next row above:

SELECT * FROM Example WHERE id > 3 ORDER BY id LIMIT 1

Select both in one query, e.g. use UNION:

(SELECT * FROM Example WHERE id < 3 ORDER BY id DESC LIMIT 1)
 UNION
(SELECT * FROM Example WHERE id > 3 ORDER BY id LIMIT 1)

That what you mean?

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. Using LIMIT within GROUP BY to get N results per group?
  3. Create a Cumulative Sum Column in MySQL
  4. How to perform grouped ranking in MySQL
  5. Equivalent of explode() to work with strings in MySQL
  6. MySQL Trigger after update only if row has changed
  7. MySQL “WITH” clause
  8. mysql select dynamic row values as column names, another column as value
  9. Ordering by specific field value first
  10. MySQL “Group By” and “Order By”
  11. MySQL DELETE FROM with subquery as condition
  12. How to change the CHARACTER SET (and COLLATION) throughout a database?
  13. MySQL Query to select data from last week?
  14. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  15. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  16. Simple Random Samples from a Sql database
  17. How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?
  18. Are there disadvantages to using a generic varchar(255) for all text-based fields?
  19. How do I use properly CASE..WHEN in MySQL
  20. Getting all parent rows in one SQL query
  21. Delete query not working in mysql
  22. How to insert data to MySQL with auto-incremented column(field)?
  23. Replace Into Query Syntax
  24. Foreign key constraints: When to use ON UPDATE and ON DELETE
  25. Does a UNIQUE constraint automatically create an INDEX on the field(s)?
  26. MySQL 5.6 – DENSE_RANK like functionality without Order By
  27. What does it mean by select 1 from table?
  28. mysql select distinct rows into a comma delimited list column
  29. Select from same table as an Insert or Update
  30. How do I limit the number of rows per field value in SQL?

Leave a Comment