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:
companyID, CompanyDept, DateAdded
Select CompanyID, CompanyDept
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