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

  • Select an option

    Learn more about clone URLs
  • Save rizalrizal/4bf5ffa01ad65fb50bdff5d9d666c991 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
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
Copy Markdown
Author

rizalrizal commented Aug 17, 2023

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