Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Islands demonstration
CREATE TABLE NumSeq (seqval int); INSERT INTO NumSeq(seqval) VALUES (2) ,(3) ,(11) ,(12) ,(13) ,(31) ,(33) ,(34) ,(35) ,(42) ; -- Inner query demonstrates how as seqval and rownum iterate by 1 each row, the difference between them remains constant at 1, creating unique 'grp's. SELECT seqval ,ROW_NUMBER() OVER(ORDER BY seqval) AS rownum ,seqval - ROW_NUMBER() OVER(ORDER BY seqval) AS grp FROM NumSeq; -- Selecting the min and max values for each group SELECT MIN(seqval) AS start_range ,MAX(seqval) AS end_range FROM( SELECT seqval ,seqval - ROW_NUMBER() OVER(ORDER BY seqval) AS grp FROM NumSeq ) AS D GROUP BY grp ORDER BY 1;
run
|
edit
|
history
|
help
0
POSTGRESQL_CLOSEST_VALUE
hell
pgsql trigger 01 - Ovocie
enrj
pgsql trigger 01 - Ovocie
Inner Join
post
Christmas Tree Generator
PostgreSQL: CASE
Return IDs where there are exactly 3 occurrences1