github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/docs/generated/sql/bnf/sort_clause.bnf (about)

     1  sort_clause ::=
     2  	'ORDER' 'BY' a_expr 'ASC' 'NULLS' 'FIRST' ( ( ',' ( a_expr ( 'ASC' | 'DESC' |  ) ( 'NULLS' 'FIRST' | 'NULLS' 'LAST' |  ) | 'PRIMARY' 'KEY' table_name ( 'ASC' | 'DESC' |  ) | 'INDEX' table_name '@' index_name ( 'ASC' | 'DESC' |  ) ) ) )*
     3  	| 'ORDER' 'BY' a_expr 'ASC' 'NULLS' 'LAST' ( ( ',' ( a_expr ( 'ASC' | 'DESC' |  ) ( 'NULLS' 'FIRST' | 'NULLS' 'LAST' |  ) | 'PRIMARY' 'KEY' table_name ( 'ASC' | 'DESC' |  ) | 'INDEX' table_name '@' index_name ( 'ASC' | 'DESC' |  ) ) ) )*
     4  	| 'ORDER' 'BY' a_expr 'ASC'  ( ( ',' ( a_expr ( 'ASC' | 'DESC' |  ) ( 'NULLS' 'FIRST' | 'NULLS' 'LAST' |  ) | 'PRIMARY' 'KEY' table_name ( 'ASC' | 'DESC' |  ) | 'INDEX' table_name '@' index_name ( 'ASC' | 'DESC' |  ) ) ) )*
     5  	| 'ORDER' 'BY' a_expr 'DESC' 'NULLS' 'FIRST' ( ( ',' ( a_expr ( 'ASC' | 'DESC' |  ) ( 'NULLS' 'FIRST' | 'NULLS' 'LAST' |  ) | 'PRIMARY' 'KEY' table_name ( 'ASC' | 'DESC' |  ) | 'INDEX' table_name '@' index_name ( 'ASC' | 'DESC' |  ) ) ) )*
     6  	| 'ORDER' 'BY' a_expr 'DESC' 'NULLS' 'LAST' ( ( ',' ( a_expr ( 'ASC' | 'DESC' |  ) ( 'NULLS' 'FIRST' | 'NULLS' 'LAST' |  ) | 'PRIMARY' 'KEY' table_name ( 'ASC' | 'DESC' |  ) | 'INDEX' table_name '@' index_name ( 'ASC' | 'DESC' |  ) ) ) )*
     7  	| 'ORDER' 'BY' a_expr 'DESC'  ( ( ',' ( a_expr ( 'ASC' | 'DESC' |  ) ( 'NULLS' 'FIRST' | 'NULLS' 'LAST' |  ) | 'PRIMARY' 'KEY' table_name ( 'ASC' | 'DESC' |  ) | 'INDEX' table_name '@' index_name ( 'ASC' | 'DESC' |  ) ) ) )*
     8  	| 'ORDER' 'BY' a_expr  'NULLS' 'FIRST' ( ( ',' ( a_expr ( 'ASC' | 'DESC' |  ) ( 'NULLS' 'FIRST' | 'NULLS' 'LAST' |  ) | 'PRIMARY' 'KEY' table_name ( 'ASC' | 'DESC' |  ) | 'INDEX' table_name '@' index_name ( 'ASC' | 'DESC' |  ) ) ) )*
     9  	| 'ORDER' 'BY' a_expr  'NULLS' 'LAST' ( ( ',' ( a_expr ( 'ASC' | 'DESC' |  ) ( 'NULLS' 'FIRST' | 'NULLS' 'LAST' |  ) | 'PRIMARY' 'KEY' table_name ( 'ASC' | 'DESC' |  ) | 'INDEX' table_name '@' index_name ( 'ASC' | 'DESC' |  ) ) ) )*
    10  	| 'ORDER' 'BY' a_expr   ( ( ',' ( a_expr ( 'ASC' | 'DESC' |  ) ( 'NULLS' 'FIRST' | 'NULLS' 'LAST' |  ) | 'PRIMARY' 'KEY' table_name ( 'ASC' | 'DESC' |  ) | 'INDEX' table_name '@' index_name ( 'ASC' | 'DESC' |  ) ) ) )*
    11  	| 'ORDER' 'BY' 'PRIMARY' 'KEY' table_name 'ASC' ( ( ',' ( a_expr ( 'ASC' | 'DESC' |  ) ( 'NULLS' 'FIRST' | 'NULLS' 'LAST' |  ) | 'PRIMARY' 'KEY' table_name ( 'ASC' | 'DESC' |  ) | 'INDEX' table_name '@' index_name ( 'ASC' | 'DESC' |  ) ) ) )*
    12  	| 'ORDER' 'BY' 'PRIMARY' 'KEY' table_name 'DESC' ( ( ',' ( a_expr ( 'ASC' | 'DESC' |  ) ( 'NULLS' 'FIRST' | 'NULLS' 'LAST' |  ) | 'PRIMARY' 'KEY' table_name ( 'ASC' | 'DESC' |  ) | 'INDEX' table_name '@' index_name ( 'ASC' | 'DESC' |  ) ) ) )*
    13  	| 'ORDER' 'BY' 'PRIMARY' 'KEY' table_name  ( ( ',' ( a_expr ( 'ASC' | 'DESC' |  ) ( 'NULLS' 'FIRST' | 'NULLS' 'LAST' |  ) | 'PRIMARY' 'KEY' table_name ( 'ASC' | 'DESC' |  ) | 'INDEX' table_name '@' index_name ( 'ASC' | 'DESC' |  ) ) ) )*
    14  	| 'ORDER' 'BY' 'INDEX' table_name '@' index_name 'ASC' ( ( ',' ( a_expr ( 'ASC' | 'DESC' |  ) ( 'NULLS' 'FIRST' | 'NULLS' 'LAST' |  ) | 'PRIMARY' 'KEY' table_name ( 'ASC' | 'DESC' |  ) | 'INDEX' table_name '@' index_name ( 'ASC' | 'DESC' |  ) ) ) )*
    15  	| 'ORDER' 'BY' 'INDEX' table_name '@' index_name 'DESC' ( ( ',' ( a_expr ( 'ASC' | 'DESC' |  ) ( 'NULLS' 'FIRST' | 'NULLS' 'LAST' |  ) | 'PRIMARY' 'KEY' table_name ( 'ASC' | 'DESC' |  ) | 'INDEX' table_name '@' index_name ( 'ASC' | 'DESC' |  ) ) ) )*
    16  	| 'ORDER' 'BY' 'INDEX' table_name '@' index_name  ( ( ',' ( a_expr ( 'ASC' | 'DESC' |  ) ( 'NULLS' 'FIRST' | 'NULLS' 'LAST' |  ) | 'PRIMARY' 'KEY' table_name ( 'ASC' | 'DESC' |  ) | 'INDEX' table_name '@' index_name ( 'ASC' | 'DESC' |  ) ) ) )*