Hi!
I've been browsing the forums a while trying to find a solution to my issue.
I have a table in SQL Server 2000 called result
with the following data;
City Price DepDate RetDate
Barcelona 145 2010-05-15 2010-05-20
New York 400 2010-06-20 2010-06-20
Barcelona 160 2010-05-17 2010-05-22
New York 325 2010-05-10 2010-05-18
Istanbul 250 2010-06-22 2010-06-27
I want to query that in SQL Server 2000 so that all columns are returned but it's distinct/uniqe on the city and only the lowest price is displayed.
So i would like it to return the following
Barcelona 145 2010-05-15 2010-05-20
New York 325 2010-05-10 2010-05-18
Istanbu 250 2010-06-22 2010-06-27
I cant for my life figure out how to do this, i should be easy and I'm sure I'm going to feel dumb when the solution is presented.
Does anyone know how to do this?
Brgds, Eric