Results 1 to 6 of 6

Thread: Filter

  1. #1
    Join Date
    Jun 2011
    Posts
    6

    Unanswered: Filter

    Dear All,

    I need to filter traveller by age.

    How to filter this for eg:

    Traveller (column) Mrs.Dolo Jaku, 72; Mr.Jame Jaku, 65; Mr.Kate blitz, 22; Ms.sheva dove, 36; Mr.James don, 22; Ms.Fleming don, 36; Mr.James Jaku, 65

    Result

    Mrs.Dolo Jaku, 72; Mr.Jame Jaku, 65;

    I need to filter all traveller whose age is greater than 65

    Any help would be highly appreciated.Many Thanks

    Reagrds, SG

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    this is really easy
    Code:
    WHERE age >= 65
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    Quote Originally Posted by r937 View Post
    this is really easy
    Code:
    WHERE age >= 65
    Or rather
    Code:
    WHERE age > 65
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by roac View Post
    Or rather ...
    well, yeah, i know he said "age is greater than 65" but he actually meant to say "greater than or equal" because if you look at his sample data, Mr.Jame Jaku is included in the desired result

    but that's not his real problem, is it

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Perhaps Jame Jaku is 65 and a half. I know, most people leave off the "half" by the time they are 8 or so, but it is still there. ;-)

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    ah, mcrowley, welcome

    i see that you too understand the real issue
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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