Supported syntax options
- Last UpdatedMar 19, 2025
- 1 minute read
The following table indicates the syntax options that are available for queries that use either the four-part naming convention (or corresponding view name) or the OPENQUERY function.
|
Syntax Element |
Four-Part Query |
OPENQUERY |
|---|---|---|
|
ORDER BY |
Yes |
No. Does not work within the OPENQUERY function. However, will work if used outside of the function. |
|
GROUP BY |
Yes |
No |
|
TagName IN ( ..) |
Yes |
Yes |
|
TagName LIKE '..' |
Yes |
Yes |
|
Date and time functions (for example, DateAdd) |
Yes |
Yes |
|
MIN, MAX, AVG, SUM, STDEV |
Yes |
MIN, MAX, AVG, SUM only |
|
Sub-SELECT with one normal SQL Server table and one extension table |
Yes, with restrictions |
No |
|
Sub-SELECT with two extension tables |
No |
No |