Specifying SELECT statements in the SQL Query Builder
Use a SELECT statement to specify criteria for returning rows from a database table.
Before you begin
Before you specify a SELECT statement, create the statement in the SQL Query Builder.
About this task
The SELECT statement is made up of several clauses including the SELECT clause, FROM clause, WHERE clause, ORDER BY clause, and GROUP BY clause.
Restriction: You cannot
create a query by using a view that is derived from a user-defined
function.
Procedure
To specify a SELECT statement in the SQL Query Builder: