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 - 2006-01-18 : 08:33:09
|
| Duleep writes "Dear support;If i have a prodyct table with different product instances with the same product name and all those instances have a different price; How can i only select product instances with the highest price.Product / Name / PriceCar - BMW £10000Car - MB £15000Car - VW £7000Computer - IBM £500Computer - DELL £250Computer - HP £750Out come should be Car - MB £15000Computer - HP £750Thanks" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Select top row for every product 