Skip to content

Instantly share code, notes, and snippets.

@cmanish049

cmanish049/row-with-second-max-id

Created January 30, 2019 14:30
Show Gist options
  • Save cmanish049/e26c7a851430155d8ccbbec41b38c31d to your computer and use it in GitHub Desktop.
Save cmanish049/e26c7a851430155d8ccbbec41b38c31d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
row-with-second-max-id
SELECT id
FROM `user`
ORDER BY id DESC
LIMIT 1
OFFSET 1 ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment