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
Employee Department Interview Questions
IOU
MS SQL Joins
ss sqlpractice2014
List longest unique string for each id
CorreçãoDeErros - UPDATE, DELETE e ALTER TABLE
Test if a string can be made with substrings!
Student
mc170400712
SQL basics(Data Definition Language)