Category: >> Oracle PL/SQL >> SELECT: Scalar Select Bookmark and Share

<< lastnext >>

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 Wi...
» SELECT: Case insensitive search
» SELECT: Partition Select
» SELECT: Select For Update
» SELECT: Using Functions
» 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
» UPDATE: Update from a SELECT state...
» Inserting into SELECT statement
» INSERT with Select

Comment: (none)

Author: CoderZone
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;
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© | users online: 22