Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Usage of joins
Create table movies ( Name varchar(30), Hero varchar(30), Rel_date date, Primary key(name) ); Insert into movies values('BAHUBALI','PRABHAS','02-jun-2015'); Insert into movies values('DESHAMUDURU','ALLU ARJUN','15-may-2007'); Insert into movies values('HELLO BROTHER','NAGARJUNA','10-jul-1998'); Insert into movies values('VENKI MAMA ','VENKATESH','02-oct-2019'); Insert into movies values('SAAHO','OPQ','20-apr-2019'); Alter table movies add hero_remuneration integer; Select * from movies; Create table movies2 ( Hero2 varchar(30), Num integer, First_mov varchar(30), ); Insert into movies2 values('PRABHAS',30,'ESHWAR'); Insert into movies2 values('ALLU ARJUN',50,'ABC'); Insert into movies2 values('NAGARJUNA',48,'XYZ'); Insert into movies2 values('SALMAN KHAN',90,'HIJ'); Insert into movies2 values('VENKATESH',77,'KLM'); Select * from movies2; Select hero,num,first_mov from movies inner join movies2 on movies.hero=movies2.hero2; Select hero,num,first_mov from movies left join movies2 on movies.hero=movies2.hero2; Select hero,num,first_mov from movies right join movies2 on movies.hero=movies2.hero2; Select hero,num,first_mov from movies cross join movies2; Select 4 from movies;
run
|
edit
|
history
|
help
0
sql_fb
SQL left join
Names
28-02
3a
ss sqlpractice2014
group_concat in sql-server
My notes
ESTEFANIA
Window Functions - ROW_NUMBER()