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 employee13 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
complicated-conditional-sql-query-to-match-attributes-for-marketing-campaigns/43219741#43219741
Library Query
Timestamps in PostgreSQL
Professional Networking Social Media Website SQL Analysis
histogram to percentiles
statistics
Movie Rating SQL Analysis Project
postgres group by by function
librarayv2
post