Агрегатные функции встроенного SQL

[oip]

Находитсь в ДевГайде поиском по слову maximum:

Цитата:

Syntax of select

SelectStatement = select Parameters

Parameters = [ [ FindOptions ] [ FieldList from ] ] TableVariable [IndexClause] [ Options ] [ Where Clause ] [ JoinClause ]

FindOptions = reverse | firstfast | firstonly | forupdate | nofetch

FieldList = Field { , Field } | *

Field = Aggregate ( FieldIdentifier ) | FieldIdentifier

Aggregate = sum | avg | minof | maxof | count

Options = ( order by | group by ) FieldIdentifier [ Direction ] { , FieldIdentifier [ Direction ] }

IndexCaluse = index Idx | index hint idx

Direction = asc | desc

WhereClause = where Expression

JoinClause = [exists | notexists | outer ] join Parameters