|
Posted by Skafa on 08/04/06 15:14
For example:
I have a table 'products' with columns id, name and price
In this table there can be duplicate product names:
1 - product1 - 10
2 - product1 - 15
3 - product2 - 12
4 - product1 - 9
I need a select query which returns unique products (by name) and if it
finds duplicates, it should return the product with the highest price.
In this case:
2 - product1 - 15
3 - product2 - 12
how can i do this ?
Remco
Navigation:
[Reply to this message]
|