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 |
|
danielfrost
Starting Member
4 Posts |
 Posted - 2004-03-18 : 10:05:55
|
| Hi guys!I have a table with some products, and there is a price column.Now I want to select a list of the most most expensive products.I've tried this, but it doesn't work. SELECT TOP 10 ProductId, Price FROM products GROUP BY ProductId, Price ORDER BY MAX(Price)Can you help me? |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-03-18 : 10:13:51
|
| HTH..SELECT TOP 10 ProductId, Price FROM products ORDER BY Price desc - Sekar |
 |
|
|
danielfrost
Starting Member
4 Posts |
Posted - 2004-03-18 : 10:34:20
|
| Sometimes I wonder how stupid I can be...!A pretty simple SQL statement...!!!Thanks anyways :) |
|
|
|
|
|
|
Selecting records