SELECT
statement helps you obtain the data you need from one or more tables.
The application of this statement will be helpful in several cases listed below:
SELECT
statement, you can use the following syntax:
SELECT
determines the data we need from the database or a table.*
referred to as select star or asterisk or represents all. It defines that the query should return all columns of the queried tables.FROM
clause indicates the table(s) to retrieve data from.table_name
represents the table(s) name.column1, column2, ...
these are used to specify the columns from where we want to retrieve the data.SELECT
statement is case insensitive, which means select
or SELECT
has the same result.public
schema. You can also display table from another specific schema.
Click here for more info.SELECT
statement within the table name to get all the data:SELECT
statement. Please refer to the syntax below: