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 :(
p.s. My platform is ms access & I need just one pure sql query. (can be also with subquerys, becose access suport it :)