sql limit sistinct records

[adybih]

Can someone help me brothers ? I have so one stupid problem.
I have table with two column: city and price. for exemple 20 prices for London and 34 prices for Paris. How can i use sql to select just 5 cheppest prices for each city ? like hear:

http://bosnic.com/sql.htm

Thank very much. if someone dont find way to help me I lose my job

 

[PHV]

One way:
SELECT A.city, A.price
FROM yourTable AS A
WHERE A.price IN (SELECT TOP 5 price FROM yourTable WHERE city=A.city ORDER BY 1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886