Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Chaudhary
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' create table book(isbn varchar(10),title varchar(10),pub_year varchar(10),unit_price varchar(10),author_name varchar(10),publisher_name varchar(10)); insert into book values(1001,'oracle',2004,399,'arora','phi'); insert into book values(1002,'dbms',2004,400,'basu','technical'); insert into book values(2001,'dos',2003,250,'sinha','nirali'); insert into book values(2002,'adbms',2004,450,'basu','technical'); insert into book values(2003,'unix',2000,300,'kapoor','scitech'); select * from book;
run
|
edit
|
history
|
help
0
Preppin Data Challenge - Week 8
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries vers.#3
Data row generator (good performance, w/o recursive CTE)
Movies
Outer Apply successer cell chek and get the result
NOT NULL field from SELECT INTO
Terceiro
using lead() and sum() with over() in mssql
Consecutive publisher publish more than 2 books for 3 days
jueves(08)