Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Movies
Create table movies ( Name varchar(30), Hero varchar(30), Rel_date date ); 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','PRABHAS','20-apr-2019'); /*Displaying 2nd rank movie based on release date*/ /* Select * from (Select name,hero,dense_rank() over(order by rel_date desc) as rnk from movies) as dummy where rnk=2;*/ Update movies set hero = 'VENKY' where name = 'VENKI MAMA'; Select * from movies;
run
|
edit
|
history
|
help
0
practice sql_12AUG
test
query
How to add namespace to sql generated XML output
Function to remove pattern occurences in a string
table creation
FIGURA5.4
SQL SERVER 2012 how to split records in a column separated by delimiter
Stuff code in sql
BRYAN_BD1