Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
student table create
CREATE TABLE student( ID INT NOT NULL IDENTITY(1,1), NAME VARCHAR(20) NOT NULL, AGE INT NOT NULL, PRIMARY KEY(ID) ); CREATE TABLE curs( ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY, NAME VARCHAR(20) NOT NULL, CREDITE INT NOT NULL CHECK(CREDITE >=0 AND CREDITE <10) ); CREATE TABLE INSERT INTO student VALUES('Dan', 23); INSERT INTO student VALUES('Fane', 23); INSERT INTO student VALUES('Alex', 22); INSERT INTO student VALUES('Rotter', 16); INSERT INTO curs VALUES('POO', 6); INSERT INTO curs VALUES('SO', 4); INSERT INTO curs VALUES('Arhitecturi', 6);
run
|
edit
|
history
|
help
0
SQL_Joins_RankingFunctions
hhzn
a
Task2_Final
Caronas
Sample
Demo
Demo
sql-server-storing-wildcards-in-data
View jobs