#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2012
    Posts
    2
    Rep Power
    0

    Mysql MAX and MIN date for same status


    I want to select the min date&time of the status 1 and max date&time of status 0 for particular date ... I need mysql query help...

    id online status

    1 2012-09-10 6:30 1
    2 2012-09-10 6:40 0
    3 2012-09-10 6:50 1
    4 2012-09-10 7:40 0
    5 2012-09-10 8:40 1
    6 2012-09-10 9:40 0
  2. #2
  3. Hockey face
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    St. Catharines, Canada
    Posts
    8,145
    Rep Power
    1316
    What have you tried so far? Please don't reply with "nothing".

IMN logo majestic logo threadwatch logo seochat tools logo