Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
sql6
Create table location ( locationid int , regionalgroup varchar(20)); insert into location( locationid , regionalgroup ) values ( 122, 'banglore'), (123 , 'delhi'), (124, 'noida'), (125, 'meerut'), (126, 'gzb'); select * from location; create table dept( deptid int, name varchar(30), locationid int ); insert into dept( deptid, name , locationid ) values( 10, 'tarun', 122), (20, 'harsh', 123), (30, 'popu', 124), (40, 'shubham', 125), (50, 'nitesh', 126); select * from dept; create table job ( jobid int , post varchar(20)); insert into job ( jobid , post) values (666, 'clerk'), (667, 'hr'), (668, 'analyst'), (669, 'senior manager'), (670, ' associate analyst'); select * from job;
run
|
edit
|
history
|
help
0
Campeonato2DLuizFelipe
TRIGGERS
StackOverflow_53753663
SQL basics(Data Definition Language)
BC160401693
Department revenue pivot
Crea, confirma y despliega tablas
Common Table Expression
group for team members and winners in sql-server
Demo