Forum: MS SQL  Jun 7th, 2008 |
| Replies: 5 Views: 2,111 Re: MS SQL query using Max
Data information
ProductA 12.00 12/10/2002
ProductA 12.50 01/15/2005
ProductA 12.01 01/02/2008
ProductB 15.12 12/01/2005
ProductB 16.00 01/09/2008
ProductB 16.24 01/15/2008 |
| Forum: MS SQL Jun 7th, 2008 |
| Replies: 5 Views: 2,111 |
| Forum: MS SQL Jun 7th, 2008 |
| Replies: 5 Views: 2,111 MS SQL query using Max
I need to write a query that will pull my products and price. However each of the products have multiple prices and I want the price with the most recent date. I have tried the following query but... |
