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 employee12 values (10,'raj','clerk','1200'); insert into employee12 values (11,'veer','piuan','1500'); insert into employee12 values (13,'shree','manager','2500'); insert into department12 values (1,'HR','1st floor'); insert into department12 values (2,'manufacturing','2nd floor'); insert into department12 values (3,'finance','3rd floor'); select*from employee12; select*from employee13; select*from department12;
run
|
edit
|
history
|
help
0
xD
Product Sales Analysis I - III
postgresql: working days
POSTGRESQL_CLOSEST_VALUE
select distinct
tegs and users
1
Select rows with no intersection on join table and check by date
PostgreSQL Sandbox: General Resale
Shortest "path" between two employees across companies