To perform a query in Apex, surround the query with square brackets. The result can be assigned to a list, or to a single object.
List<Account> allAccounts = [SELECT Id, Name FROM Account];
Account oldestAccount = [SELECT Id, Name FROM Account ORDER BY CreatedDate LIMIT 1];