Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
a
create table course ( cid int primary key, cname varchar(20) unique ) create table student ( sid int primary key, sname varchar(20), notnull, age int default 14, gender varchar(2), constraint chk_student check(gender in ('M' or 'F')) )
run
|
edit
|
history
|
help
0
code
subquery & correlated subquery & "is null" condition
SQL Server - regex filtering using LIKE
Transpose group per sequence
Null as default value
List longest unique string for each id
Cine latino
cinema latinoamericano
Consecutive publisher publish more than 2 books for 3 days
SS my sql server 2014 4/7