Skip to content

Instantly share code, notes, and snippets.

@ipang-dwi
Created August 4, 2022 08:56
Show Gist options
  • Save ipang-dwi/6c7cafc18ed5731eca90039f5d086980 to your computer and use it in GitHub Desktop.
Save ipang-dwi/6c7cafc18ed5731eca90039f5d086980 to your computer and use it in GitHub Desktop.
select row_number() over (order by id_wisata) as rnk, id_wisata, lat, lng
from wisata
where nik = "-"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment