Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Assignment 1(SET A)
Create table Employee12( eno int primary key,ename varchar(20), designation varchar(20), salary float (20)); Create table Department12( dno int primary key,dname varchar(20),loc varchar (50)); -- one to many relationship create table Employee13 ( eno int primary key, ename varchar (20), designation varchar (20), Salary float(20), employee_department12 int references department12(dno)); Insert into Emp1(11,'raj','clerk','1200'); Insert into Emp2(12,'veer','piuan','1500'); Insert into Emp3(13,'shree','clerk','1500'); Insert into Emp4(14,'nil','manager','2500'); Insert into dept1(101,'HR', '1st floor'); Insert into dept2(102,'manufacturing','2nd floor'); Select * from department 1; Select dno from department12 where dname 'HR';
run
|
edit
|
history
|
help
0
project 1
SQL primes, sqrt sieve
Yy
xD
first
SQL social network practice by Han Wang 20200720 - 2
test
PostreSQL: Subquery
select from json[]
Return IDs where there are exactly 3 occurrences