Results 1 to 3 of 3
Thread: Limit Distinct Records ???
Feb 7, 2006, 15:25 #1
- Join Date
- Feb 2006
- 0 Post(s)
- 0 Thread(s)
Limit Distinct Records ???
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
Last edited by ady_bih; Feb 7, 2006 at 16:26.