nguyennd (4/27/2010)
Huhu = hic hic 😀
Hmmm...hic hic doesn't mean anything to me either. Is it laughter?
Thank Paul, very very ...
But why do you use
MAXPRICE = MAX(D.Price) OVER (PARTITION BY D.DetailKey)
, i don't understand 😀
Just in case you needed it - it's not important for the result in this case.
You can safely take it out.