SQL SELECT is the most frequently used SQL command. The SQL SELECT command is used to retrieve data from one or more database tables.The SQL statement below shows a simple usage of the SQL SELECT command:

1

SELECT FirstName, LastName, DateOfBirth FROM Users

You can use the following SQL query to make an exact copy of the data in the Users table:

1

SELECT * INTO UsersBackup FROM Users

There is a special syntax that can be used with the SELECT command, if you want to retrieve all columns from a table. To do that, replace the list of columns with the * symbol:

1

SELECT * FROM Users