SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Feb 2006
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    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.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,015
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    Quote Originally Posted by ady_bih
    if someone dont find way to help me I lose my job
    sorry, i don't believe you

    this sounds too much like a homework question

    what have you tried? show some queries
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I would advice you get a book or go for some training


Bookmarks

Posting Permissions

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