Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SQL Sequence
CREATE TABLE Products ( Id INT ) CREATE SEQUENCE Seq AS INT START WITH 1 INCREMENT BY 1 INSERT INTO Products (Id) VALUES (NEXT VALUE FOR Seq), (NEXT VALUE FOR Seq), (NEXT VALUE FOR Seq) SELECT * FROM Products DELETE FROM Products ALTER SEQUENCE Seq RESTART ALTER SEQUENCE Seq MINVALUE 1 MAXVALUE 5 INCREMENT BY 3 CYCLE INSERT INTO Products (Id) VALUES (NEXT VALUE FOR Seq), (NEXT VALUE FOR Seq), (NEXT VALUE FOR Seq), (NEXT VALUE FOR Seq), (NEXT VALUE FOR Seq) SELECT * FROM Products
run
|
edit
|
history
|
help
0
MERGE WITH OUTPUT
Emp Table
Using varaible
deepu
Miglior film animato
Running Total
SI 1
ex2
SQLERROR
STACK