Retrieving Data from Tables

Learn to extract data from database tables using SELECT.

There is no use in having data if we cannot view it and work with it. We can use the SELECT command to retrieve data from tables in a database. Just like with inserting, there are several ways we can use this command.

Retrieve data from all columns

To retrieve all columns, we use this syntax:

SELECT * FROM TableSchema.TableName;

Let’s create the dbo.Students table, insert some data, and retrieve it afterward:

Get hands-on with 1200+ tech skills courses.