Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

PI SQL Data Access Server (RTQP Engine)

COUNT

  • Last UpdatedDec 19, 2022
  • 1 minute read

The COUNT function returns the number of items found in a group.

Syntax

Int32 COUNT()
Int32 COUNT(x Int8, optional)
Int32 COUNT(x Int16, optional)
Int32 COUNT(x Int32, optional)
Int32 COUNT(x Int64, optional)
Int32 COUNT(x UInt8, optional)
Int32 COUNT(x UInt16, optional)
Int32 COUNT(x UInt32, optional)
Int32 COUNT(x UInt64, optional)
Int32 COUNT(x Single, optional)
Int32 COUNT(x Double, optional)
Int32 COUNT(x Boolean, optional)
Int32 COUNT(s AnsiString, optional)
Int32 COUNT(s String, optional)
Int32 COUNT(x DateTime, optional)
Int32 COUNT(x Guid, optional)
Int32 COUNT(x Variant, optional)
Int32 COUNT(x Binary, optional)
Int32 COUNT(x TimeSpan, optional)

Arguments

  • x

    Can be any supported data type.

In This Topic
Related Links
TitleResults for “How to create a CRG?”Also Available in