Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-01 : 09:50:42
|
| Bolin writes "I have a table (pricelist) of three columns (store, brand, price). I need to know the store, brand, and price of the cheapest price per store. I have tried to use the following SQL command, but I cannot find a way to include the brand of the cheapest price per store along with the store and price.select store, min(price)from pricelistgroup by storewhere" |
|
|
|
|
|
Group By problem