SitePoint Sponsor

User Tag List

Results 1 to 10 of 10

Thread: max date

Threaded View

  1. #1
    SitePoint Zealot
    Join Date
    Jan 2010
    Posts
    130
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    max date

    I have 2 tables


    Code:
    id|name
    -+----------
    1|st1
    2|an2
    1|st1
    2|an2
    --------------
    
    id|date
    -+----------
    1|2002
    2|2003
    1|2010
    2|2011
    --------------
    i want to retrive max date with name like this
    Code:
    name|date
    ---+----------
    st1 |2010
    an2|2011
    --------------
    any help??
    Last edited by ScallioXTX; May 26, 2013 at 11:05. Reason: Wrapped table examples in [code][/code]


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
  •