Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
TEST-A3
Create table STUDENT(USN int primary key ,Sname varchar(20) NOT NULL ,Address varchar(50) ,Phone int ,Gender varchar(10)); Create table SEMSEC(SSID int primary key ,Sem int , Sec varchar(10)); Create table CLASS(USN int , SSID int , foreign key(USN) references STUDENT(USN),foreign key(SSID) references SEMSEC(SSID)); Create table SUBJECT(Subcode varchar(10) primary key ,Title varchar(30) ,Sem int , Credits int ,SSID int ,foreign key(SSID) references SEMSEC(SSID)); insert into Student(USN,Sname,Address,Phone,Gender) values(1,'Anubhav','abc',750011,'Male'),(2,'Anupam','abcd',751111,'Male'),(3,'Adnan','ab',751011,'Male'),(4,'Anush','abcde',75011,'Male'),(5,'Dhanush','abce',750111,'Male'); Select * from student; insert into SEMSEC(SSID,Sem,Sec) values (200,4,'A'),(201,3,'B'),(202,4,'C'),(203,4,'C'),(204,3,'C'); Select * from SEMSEC; insert into CLASS(USN,SSID) values(2,201),(1,200),(3,201),(4,204),(5,203); Select * from CLASS; insert into SUBJECT(Subcode,Title,Sem,Credits,SSID) values ('DD','Digital Design',4,4,200),('DS','Data Structures',3,4,201),('OOPS','Object Oriented Programming',4,5,202),('DBMS','Database management',4,5,203),('GT','Graph Theory',3,3,204); Select * from SUBJECT; Select S.USN,S.Sname,S.Address,S.Phone,S.Gender from STUDENT as S, SEMSEC as SE, CLASS as C where S.USN=C.USN and C.SSID=SE.SSID and SE.Sem=4 and SE.Sec='C';
run
|
edit
|
history
|
help
0
Libros
TSQL - Logic driven by two most recent rows
03_A_Group_by_having
Terceiro
Except Insert missing
TSQL - Unique string generator
add-empty-rows-after-certain-records-in-a-table
SQL_BASIC
Chaudhary
Sql Question 1