- HubPages»
- Technology»
- Computers & Software»
- Computer Software
Capablities of SELECT Statements
SELECT statement is used to retrieves information form the database. Oracle, SQL, MySQL etc. supports SELECT statement. As SELECT statement retrieves data, it can do three types of work (1) projection, (2) selection and (3) joining. This page describes the capabilities of SQL SELECT statements.
Capabilities of SELECT statement:
SQL SELECT statement can do the following three types of work:
- Projection
- Selection
- Joining
All of them are described below:
Projection
By using SQL SELECT statement you can project or select all or the specific columns. It's primary goal is to select only the columns. The selected columns may be all the columns of the table. You can choose few or all the columns according to your queries.
Selection
By using SELECT statement, you can select the specific no of rows form the table. You can restrict the rows by applying several conditions. In this case, SELECT statement is used as filtering.
Joining
By using SELECT statement, you can join different types of table. Use join capabilities to bring together data that is stored in different tables by creating a link between different tables.
Summary of SELECT statements
SELECT statements can retrieve data by 3 ways:
- Projection: Select columns
- Selection: Select rows
- Joining: Join different tables data
© Written by rancidTaste
If you are enjoyed this post, please consider to give a thumbs up and leave a comment. You may Subscribe to rancidTaste's RSS feed to get new pages which will be delivered to your feed reader. You can also read more hubs by rancidTaste.
JOIN HUBPAGES & ENJOY WORLD'S BEST WRITINGS