Snippet Name: SELECT: Scalar Select
Description: The scalar SELECT command retrieves columns and rows from a table based on specified criteria.
Use the optional TOP keyword to display only the first num_rows number of rows of the query results that match the selection criteria. If you include the TOP keyword, you must also include an ORDER BY clause to order (or sort) the selected rows.
Also see:
» TABLE: Using Select Statement With Data
» SELECT: Case insensitive search
» SELECT: Partition Select
» SELECT: Select For Update
» SELECT: Using Functions
» SELECT: Get DISTINCT or UNIQUE values
» SELECT: Get UNIQUE and DISTINCT values
» SELECT with HAVING Clause
» SELECT with GROUP BY Clause
» SELECT with WHERE Clause
» SELECT with SAMPLE clause
» SELECT placement
» SELECT into a table
» SELECT name columns
» SELECT
» UPDATE: Update from a SELECT statement
» Inserting into SELECT statement
» INSERT with Select
Comment: (none)
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 05th, 2009
|
SELECT [ TOP num_rows ] { * | scalar_column_expr [ AS alias_name ],... }
FROM [ database_name.]object_name
[ WHERE condition ]
[ ORDER BY column_name_or_alias [ ASC | DESC ] ,... ];
SELECT * FROM call.status WHERE Item_Severity = 4;
-- in this example, the virtual column Item_Severity + Tally is
-- populated by adding the values of the two columns together:
SELECT Item_Severity, Item_Severity + Tally FROM call.status;
|
