where

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.

WHERE Clause Read More »

Scroll to Top