select

Description

Retrieves rows from database objects.

Syntax

select [all | distinct] select_list 
 [into [[database.]owner.]table_name] 
 [from [[database.]owner.]{view_name|table_name
  [(index index_name [ prefetch size ][lru|mru])]}
         [holdlock | noholdlock] [shared]
     [,[[database.]owner.]{view_name|table_name
  [(index index_name [ prefetch size ][lru|mru])]}
         [holdlock | noholdlock] [shared]]... ] 
 
 [where search_conditions] 
 
 [group by [all] aggregate_free_expression
    [, aggregate_free_expression]... ]
 [having search_conditions]
 
 [order by 
 {[[[database.]owner.]{table_name.|view_name.}]
     column_name | select_list_number | expression}
         [asc | desc]
 [,{[[[database.]owner.]{table_name|view_name.}]
     column_name | select_list_number | expression} 
         [asc | desc]]...]
 
 [compute row_aggregate(column_name)
         [, row_aggregate(column_name)]...
     [by column_name [, column_name]...]] 
 
 [for {read only | update [of column_name_list]}]
 
 [at isolation {read uncommitted | read committed |
 	serializable}]
 
 [for browse]
[plan "abstract plan"]

Usage

Usage


Server Class ASEnterprise


Server Class ASAnywhere


Server Class ASIQ


Server Class sql_server


Server Class direct_connect


Server Class db2

See also

See Also

select in the Adaptive Server Reference Manual.