Select date time for the different status of the field

[chidambaram1987]

I am looking for help to select the datatime of the particular status .. 1) Min date time for staus 1 and 2) Max date time for status 2

+---------------------+--------+
| online | status |
+---------------------+--------+
| 2012-10-09 21:30:12 | 1 |
| 2012-10-09 22:30:24 | 0 |
| 2012-10-09 23:30:44 | 1 |
| 2012-10-09 23:30:47 | 0 |
+---------------------+--------+

Min time of status 1 and max time of status 0 is required please

[Old Pedant]

SELECT MIN( IF(status=1,online,'2099-12-31') ) AS minStatus1,
       MAX( IF(status=2,online,'1900-1-1') ) AS maxStatus2
FROM table

Naturally, the "dummy" values there (2099-12-31 and 1900-1-1) can be anything you choose that are outside the possible range of value in your actual data.

[Old Pedant]

You could also force the code to get a NULL if there isn't any match on status=1 or status=2, if you need that:

SELECT IF( x.s1 = '2099-12-31', NULL, x.s1 ) AS minStatus1,
       IF( x.s2 = '1900-1-1', NULL, x.s2 ) AS maxStatus2
FROM (
    SELECT MIN( IF(status=1,online,'2099-12-31') ) AS s1,
           MAX( IF(status=2,online,'1900-1-1') ) AS s2
    FROM table
    ) AS x

But if you know there is at least one good value for status=1 and one good value for status=2 then don't bother with that.