Skip to content

Instantly share code, notes, and snippets.

@rizalrizal

rizalrizal/query_get_after_before_row.sql

Created August 17, 2023 03:36
Show Gist options
  • Save rizalrizal/4bf5ffa01ad65fb50bdff5d9d666c991 to your computer and use it in GitHub Desktop.
Save rizalrizal/4bf5ffa01ad65fb50bdff5d9d666c991 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query_get_after_before_row.sql
SELECT * FROM (SELECT @rownum := @rownum + 1 AS rank ,t.* FROM t_kontrak t, (SELECT @rownum := 0) r ORDER BY id ASC) tr
WHERE tr.rank IN
(
SELECT (rank-1) AS rank FROM (SELECT @rownumdlm := @rownumdlm + 1 AS rank ,t.id FROM t_kontrak t, (SELECT @rownumdlm := 0) r ORDER BY id ASC) td WHERE td.id=1906
);
@rizalrizal
Copy link
Author

Untuk mencari data sebelum dan sesudah baris

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment