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 Emp12(101,'raj','clerk','1200'); Insert into Emp12(102,'veer','piuan','1500'); Insert into Emp12(103,'shree','clerk','1500'); Insert into Emp12(104,'nil','manager','2500'); Select * from employee1;
run
|
edit
|
history
|
help
0
as
Testing psql
finaleHFEIZFIDSHI
PostreSQL: warehouse table
SQL2_CLASS
remove properties from jsonb using function jsonb_set of PostgreSQL
asd
Update as a function result
sss
base de datos api teclab