[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test.
Chapter 2: Introducing SQL introduces you to writing simple queries using SELECT statement. It also introduces you to filtering and sorting data.
- 2 Retrieving Data Using the SQL SELECT Statement
- 2.1 Explain the capabilities of SQL SELECT statements
- 2.2 Execute a basic SELECT statement
- 3 Restricting and Sorting Data
- 3.1 Limit the rows that are retrieved by a query
- 3.2 Sort the rows that are retrieved by a query
- 3.2 Use ampersand substitution to restrict and sort output at runtime
Reading Material
- Retrieving Data Using the SQL SELECT Statement
- Basic Elements of Oracle SQL
- Operators
- Sorting Query Results
- SQL for Beginners (Part 1) : The SELECT List
- SQL for Beginners (Part 2) : The FROM Clause
- SQL for Beginners (Part 3) : The WHERE Clause
- The WHERE clause
- Row Limiting Clause
- The ORDER BY Clause
- SQL*Plus 10.1 Substitution Variables
- Using Substitution Variables
- On ROWNUM and Limiting Results
- Row Limiting Clause for Top-N Queries