Retrieving and Sorting Data
- Limit the retrieve rows
- Sort the rows
- Substitution variables
You may also like
Retrieving Data Using the SQL Select Statement
17 March, 2017
Basic SELECT statement Arithmetic expressions and NULL values Column alias Concatenation operator Literal character string Alternative quote operator DISTINCT keyword DESCRIBE command
Using Single – Row Function
17 March, 2017
Single-row SQL Functions Character Functions Number Functions Working with dates Date Functions
Using Conversion Functions and Conditional Expression
17 March, 2017
Implicit and explicit data type conversion TO_CHAR, TO_DATE, TO_NUMBER functions Nested Functions General Functions CASE and DECODE Conditional expressions



