Do you have a question? Post it now! No Registration Necessary. Now with pictures!
May 29, 2005, 4:02 pm
rate this thread
I was hoping someone could help me out here.
I have a table which has columns seq and price. Some sample rows are...
I would like to return the single row which the largest seq number and
smallest price within that seq group. So for the example above the
second to last row would be returned (seq=4, price=30).
I am running MySQL 4.0.20 so unfortunately I cannot do subqueries.
Would someone be able to suggest how this could be done with joins?
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum