Scribd
Upload
46 views1 page

Select Statement

The SELECT statement allows users to query and retrieve data from database tables and views. It returns a result set of rows with the same number of columns. The SELECT statement can be used to select all attributes and tuples from a table, or specific attributes and all tuples, by listing the desired columns separated by commas after the SELECT keyword.

Uploaded by

Priyanka
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
46 views1 page

Select Statement

The SELECT statement allows users to query and retrieve data from database tables and views. It returns a result set of rows with the same number of columns. The SELECT statement can be used to select all attributes and tuples from a table, or specific attributes and all tuples, by listing the desired columns separated by commas after the SELECT keyword.

Uploaded by

Priyanka
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SELECT: The SELECT statement allows you to fetch data from tables or views.

The result of the


SELECT statement is called a result set that is a list of rows, each consisting of the same number of
columns. With the help of SELECT statement we can perform multiple tasks like:
 Querying Data: This is a simple mechanism of retrieving information from tables, following
are different ways to retrieve information:
o Select all attributes and tuples from a table:
SELECT * FROM table_name;

o Select few attributes and all tuples from a table:


SELECT attribute_list(comma separated) FROM table_name;

You might also like