Getting rows containing max date

Discussion in 'MySQL' started by KingCobra, May 26, 2009.

0
  1. #1
    I have a table named 'news' with following data


    news_id news_date news_details
    ------- ----------- -------------
    111111 2009-03-30 News details here
    333333 2009-05-14 details eb ert berjtber
    222222 2009-04-30 News 222222 title here
    444444 2009-05-14 detaaaaisidj sdsd kse


    what will be the mySQL query to produce rows containg max date?
    The output will be -


    333333 2009-05-14 details eb ert berjtber
    444444 2009-05-14 detaaaaisidj sdsd kse
     
    KingCobra, May 26, 2009 IP
  2. My220x

    My220x Member

    Messages:
    624
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    35
    #2
    By max date you mean a date you specify or just the latest dates?
     
    My220x, May 26, 2009 IP
  3. KingCobra

    KingCobra Well-Known Member

    Messages:
    289
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    103
    #3
    latest dates or higher date
     
    KingCobra, May 26, 2009 IP
  4. KingCobra

    KingCobra Well-Known Member

    Messages:
    289
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    103
    #4
    Solved By Me
     
    KingCobra, May 26, 2009 IP