Developing By Me

Project Development and Design

SELECT

SELECT

The SELECT clause has several different ways to return data. If the * is used the statement will return all fields for the returned rows. However, it can be limited by defining which fields or columns are required to be returned. It is also possible to use the syntax of table.* which will return every value from the specified table. All of these options are useful and the Database Administrator [DBA] needs to keep in mind how much data is being returned in the columns because larger datasets can take a longer time to return and may have unnecessary information for the application of that data. The following are several different syntax examples of the SELECT clause:

 

SQL Syntax Description
SELECT *  Returns all fields
SELECT table.*  Returns all fields from the specified table
SELECT table.field1, table.field2  Returns only fields 1 & 2 from the table

%d bloggers like this: