面试时遇到的SQL
时间：2022-03-14 02:45
| CustomerID | |||
| CustomerID | Month | ProductName | MaxPrice |
| C001 | 11 | POM | 310 |
| C001 | 10 | HDPE | 400 |
| C002 | 9 | EVA | 300 |
| C003 | 11 | HDPE | 600 |
| C003 | 8 | POM | 300 |
怎么写SQL呢？
我的思路是这样的，不知道对不对。
Select T2.CustomerID,T2.Month,Tbl.ProductName,T2.MaxPrice
From
(
Select CustomerID,Datetime.Month Month,MaxPrice
From Tbl
Group by Tbl.CustomerID,Datetime.Month
) T2
Inner Join Tbl
On T2.CustomerID = Tbl.CustomerID
And T2.Month = Tbl.DateTime.Month
And T2.MaxPrice = Tbl.Price
