Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
emp 4
Create table location ( location id int , regional group varchar(20)); insert into location( location id , regional group ) values ( 122, 'banglore'), (123 , 'delhi'), (124, 'noida'), (125, 'meerut'), (126, 'gzb'); select * from location; create table dept( dept id int, name varchar(30), location id int ); insert into dept( id, name , location id ) values( 10, 'tarun', 122), (20, 'harsh', 123), (30, 'popu', 124), (40, 'shubham', 125), (50, 'nitesh', 126); select * from dept; create table job ( job id int , function varchar(20)); insert into job ( id , function) values (666, 'clerk'), (667, 'hr'), (668, 'analyst'), (669, 'senior manager'), (670, ' associate analyst'); select * from job;
run
|
edit
|
history
|
help
0
BRYAN_BD1
Common Table Expression
FIGURA5.4
customers
practice sql_12AUG_Upddated
Libros
Demo
SALESPEOPLE
№5
COMPUTED COLUMN