WHERE Clause

#Renaming a column with the AS command.
SELECT
col#,
segcollength,
offset,
name AS COLUMN_NAME,
type#,
length

FROM
col$
WHERE
COL# = 1;

Rules:

Where clause requires the original column name. They will not accept the renamed column name.

Restricts the number of rows. It does not group.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top