Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
check constraint
CREATE TABLE person (id INTEGER PRIMARY KEY NOT NULL, name TEXT, age INTEGER, genderid INTEGER) insert into person(id,name,age,genderid)values(1001,'yokesh',19,1) insert into person(id,name,age,genderid)values(1002,'rajesh',19,-1) alter table person add constraint age_const check (age>18 and age<=55) insert into person(id,name,age,genderid)values(1003,'rajesh',55,-1) select* from person alter table person drop constraint age_const insert into person(id,name,age,genderid)values(1004,'ramh',99,1) select* from person
run
|
edit
|
history
|
help
0
№3
SS Sqlsvr2014 practice
mySQL_Glx_12dec
SQL_Joins_RankingFunctions
Preppin Data Challenge - Week 9
Group by
Delete double entries from a table without primary key
Loading json file into sql server
Solution 1
Calculation of a status life duration