The basic query

The simplest possible SELECT query is

SELECT *
FROM tablename

For example, the following SELECT query will return all columns of all records in the Employees table:

SELECT *
FROM Employees

The asterisk indicates that all columns of the desired table(s) are to be retrieved. You could also specify only certain columns:

SELECT FirstName, LastName
FROM Employees