Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
First Query
create table Test(ID int not null, Name char(100) not null, salary int not null, DeptID int not null); insert into Test(ID,name,salary,DeptID) Values(22004564,'sravani',20000,10); insert into Test(ID,name,salary,DeptID) values(22004565,'nisha',30000,20); insert into Test(ID,name,salary,DeptID) values(22004508,'shruti',40000,30); select * from Test; create table Dept(DeptID int not null, DeptName char(50) not null); insert into Dept(DeptID,DeptName) values(10,'IT'); insert into Dept(DeptID,DeptName) values(20,'HR'); insert into Dept(DeptID,DeptName) values(30,'Automation'); select * from Dept; select t.ID,t.Name,dp.DeptID from Test t, Dept dp where t.DeptID = dp.DeptID;
run
|
edit
|
history
|
help
0
M0413045.sql
№1
TEST 2
test22
1D Hotel
q
SinghDestiny
Demo
№3
see a quell