查询练习(1) --力扣

如题：

-- MS SQL Server
-- Create database 'LeetCode'
if (exists(select * from master.dbo.sysdatabases where name='LeetCode'))
	begin
		use master
		drop database LeetCode
		select 1
	end
else
	begin
		select 0
	end
go
Create Database LeetCode
go
exec sp_databases
go

-- begin
use [LeetCode]
go

-- Create table 'Weather'
if (exists(select * from sys.objects where name='Weather'))
	drop table Weather
go
Create table Weather(Id char(5), RecordDate DATE, Temperature int)
go
Insert into Weather values(1, '2015-01-01', 10), (2, '2015-01-02', 25), (3, '2015-01-03', 20), (4, '2015-01-04', 30)
go
select * from Weather
go
exec sp_help Weather
go
select * from sysobjects where xtype='U'
go

-- Application
select * from Weather w1
	left join Weather w2
	on datediff(d, w1.RecordDate, w2.RecordDate)=1
go

select w2.* from Weather w1
	left join Weather w2
	on datediff(d, w1.RecordDate, w2.RecordDate)=1
	where w1.Temperature<w2.Temperature
go