SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Threaded View

  1. #1
    SitePoint Member
    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:
    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts