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
SS mysqlsvr 2014 practice
Turn comma-separated numbers in string into rows
SQL CASE WHEN
QUAN LY CHUYEN BAY
count events by 2 shift cycles using derived table
Dbms_20181cse0068
20181117
TEST-A3
Service broker
pk