I'm trying to do a simple select statement but I'm having a hard time doing it. I have a table with these columns :
Select CompanyID, CompanyDept where min(dateAdded)
You can try just getting the first record using TOP 1 and ordering by date.
SELECT TOP 1 CompanyID, CompanyDept FROM Table ORDER BY dateAdded