SQL Query Help

ozzii · #1 (**permalink**) 02-12-11, 13:31

Hi,

I have a table called tbl_users.

Code:

Id | Name         | Date_Registered      | Company_Name
____________________________________________________
1  | name_x       | 2011-02-01 16:44:17  | company_1
2  | name_y       | 2011-02-02 15:34:17  | company_2
3  | name_z       | 2011-02-02 15:34:17  | company_1

How do I select only those users that registered first from each company?

so the from the above table only users 1 and 2 should be retreived.