retrieving records by timestamp

[JOBARAM]

hi,
I have the following table:

ID |Type |TimeStampe

10 |1 |2005-04-25 16:37:58
10 |2 |2005-04-25 16:39:58
10 |3 |2005-04-25 16:38:58
10 |4 |2005-04-25 16:38:58


I need to create a query that will get me 2 types (limit 2) that have the oldest timestamp (1 and 3).

How do I do that?

Thanks

Jo

 

[TonyGroves]

How about:
[tt]
SELECT * FROM tblname
ORDER BY timestampe
LIMIT 2
[/tt]

 

[JOBARAM]

Hi Tony,
I have done some thing similar and it works:

SELECT
*
FROM
table_name
ORDER BY
datetime_field ASC
LIMIT 0, 2

Thanks mate

Jo