Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- use
- [AdventureWorksDW2012]
- go
- ;WITH sales AS (
- select d.OrderDateKey,
- SalesAmount = SUM(d.SalesAmount)
- from [dbo].[FactInternetSales] d
- group by d.OrderDateKey
- having SUM(d.SalesAmount)>10000
- )
- select FirstOrderDateKey = MIN(OrderDateKey)
- from sales
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement