我的Server 2014中有一个表:
CREATE TABLE [dbo].[tblTradeSuggestions]
(
[StockId] [bigint] NOT NULL,
[DateGreg] [bigint] NOT NULL, -- Date Stored as yyyymmdd
[TradeSuggestion] [nvarchar](50) NOT NULL,
[ClosePrice] [real] NOT NULL
) ON [PRIMARY]
上表的DCL & DML脚本可以从下载。
现在我需要两个查询(a& b)如下: