join two tables with max aggrigation on one table
I have two tables:
+Material: -ID +Price: -BookPrice -PriceDate -MaterialID
i want to get all materials and their lastPrice(Price row with latest
PriceDate). i use sql server. Thanks in advance!
No comments:
Post a Comment