O'Reilly logo

Oracle® Web Application Programming for PL/SQL® Developers by Benjamin Rosenzweig, Solomon Morse, Melanie Caffrey, Susan Boardman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Unit 8.1. SQL Basics

Clauses of the Select Statement

Table 8.1 shows the clauses and keywords of a SELECT statement. The clauses are listed in the recommended order for an actual SELECT statement.

The most basic SELECT statement is one with only a SELECT and FROM clause. The SELECT clause lists the columns to be included in the result set. The FROM clause lists the tables from which to select the data.

FOR EXAMPLE

SELECT first_name, last_name 
  FROM student; 

This will select the first name and last name columns for all of the rows in the student table. To limit the number of rows returned, the WHERE clause is needed. The WHERE clause has two ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required