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
Query integer in text field - Seemingly doesn't work as expected
Professional Networking Social Media Website SQL Analysis
Descriptor test
Transform sequential key value data to row based key value data
Q4
3c
Ankit
lol
jsonb handle
Yandex Task