Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Am unable to use LAG function and Over clause in SWQL anyone help me

Am unable to use LAG function and Over clause in SWQL anyone help me

Find more posts tagged with

sql

SWQL

Accepted answers

LAG and OVER are supported in Transact-SQL (see https://learn.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver16). SWQL is designed to mimic SQL, but it doesn't support all SQL operations. See https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions for the list of supported SWQL functions.

All comments

LAG and OVER are supported in Transact-SQL (see https://learn.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver16). SWQL is designed to mimic SQL, but it doesn't support all SQL operations. See https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions for the list of supported SWQL functions.

Quick Links