Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
First Query
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
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;
View schema
Execution time: 0,02 sec, rows selected: 9, rows affected: 6, absolute service time: 0,22 sec, absolute service time: 0,22 sec
edit mode
|
history
|
discussion
ID
Name
salary
DeptID
1
22004564
sravani
20000
10
2
22004565
nisha
30000
20
3
22004508
shruti
40000
30
DeptID
DeptName
1
10
IT
2
20
HR
3
30
Automation
ID
Name
DeptID
1
22004564
sravani
10
2
22004565
nisha
20
3
22004508
shruti
30