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
TSql - Unroll inventory transactions and compute daily average
[SQLS]-Split and update a column
Lisber-SQL-Example(CASE)
NAMES CODE
extract part of a string
CorreçãoDeErros - UPDATE, DELETE e ALTER TABLE
New
Mass Insert using Except
Stuff code in sql
Sql Server's curse