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:
All of them are described below:
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.
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.
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
More by this Author
- 64How to check CPU temperature:A complete guide to Check CPU temperature through BIOS or software on all operating system
While CPU is running, it produces heat. CPU is an electronic device. It is very urgent to remove heat from electronic devices as soon as possible. Otherwise the internal temperature will be increased. If the device is...
Solution of the Oracle installation problem on Windows 7 / Windows XP during Oracle installation start-up. Know the reasons and solution of the erro "CreateFile error 32 when trying set file time" Error During...
- 5How to Reset/Remove/Bypass a BIOS or CMOS Password? : A Complete Guide to Reset/Remove/Bypass BIOS or CMOS Password
User level passwords are used to restrict unauthorized access of a computer. BIOS or CMOS passwords are used to prevent access to BIOS settings or to prevent PC from booting. Thus BIOS passwords are used to add or...