Re: Definition please....

Tundra wrote:
> When refering to SQL statements what would a predicate be and would
> the Distinct keyword be considered a predicate?

A predicate is something that evaluates to either true or false. DISTINCT is a keyword. The predicates of your query are those that narrow down the result relation, they're mostly part of the WHERE clause. Eg:

--No predicates
SELECT id FROM table;

--A single predicate that evaluates to true/false and allows --the row conditions that evaluate to true. SELECT id FROM table
WHERE id > 100;

Morten Received on Wed Mar 27 2002 - 12:16:54 CET