Skip to content

Instantly share code, notes, and snippets.

@ikesnowy

ikesnowy/v2ex.sql

Created March 11, 2022 08:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ikesnowy/adf4d7b9690d2e38c74ed00877fcc3fd to your computer and use it in GitHub Desktop.
Save ikesnowy/adf4d7b9690d2e38c74ed00877fcc3fd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
v2ex.sql
select a, b, c
from table1
where a in ('123', '456', '789') and id = (select min(id) from table1 as mirror where mirror.a = table1.a);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment