修改选择语句(modify select statement)

修改选择语句(modify select statement)

我试图修改这个选择语句

SELECT Month ,Day ,AvgLo 'Average Low' FROM dbo.Weather

为今天的日期产生平均最低值。 然后让它将数据添加到名为TodayWeather的新表中。 我将如何去完成这件事？

I’m trying to modify this select statement

SELECT Month ,Day ,AvgLo 'Average Low' FROM dbo.Weather

to produces that Average Low for only today’s date. And then have it add the data to a new table called TodayWeather. How would I go about getting this done?

最满意答案

CREATE VIEW TodaysWeather SELECT [Month] ,[Day] ,AvgLo 'Average Low' FROM dbo.Weather WHERE [Month] = MONTH(GETDATE()) AND [Day] = DAY(GETDATE())

这将永远是最新的:)

CREATE VIEW TodaysWeather SELECT [Month] ,[Day] ,AvgLo 'Average Low' FROM dbo.Weather WHERE [Month] = MONTH(GETDATE()) AND [Day] = DAY(GETDATE())

This will always be up to date :)