The SELECT statement is used to retrieve data from a table. The general form is as under.

Select fieldname1, fieldname2, fieldname3,…
from tablename;

When retrieving multiple columns, specify each field name. A comma must separate field names. The columns will display in the order you select them.

To select the content of columns named " FirstName" and " LastName" and “Email”, from the database table called " empinfo", use a SELECT statement like this:

empinfo

SELECT FirstName, LastName FROM  empinfo;

SELECT * FROM empinfo;

When a SQL query returns one or more rows of data, you can use the ResultSet object to get the description of the result set and to navigate within the rows of the results to retrieve the data.

The DISTINCT command is used with SELECT keyword to retrieve only unique data entries depending on the column list you have specified.  

empinfo

SELECT DISTINCT FirstName from empinfo;

The Result will be.