[Video] SQL Tricks and Tips

Hey Community!

We're happy to share a new video from our InterSystems Developers YouTube:

⏯  SQL Tricks and Tips @ Ready 2025

https://www.youtube.com/embed/WjE3JkDU-EU
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

This presentation introduces two helpful SQL features in InterSystems IRIS: Common Table Expressions (CTEs) and Limit/Offset. CTEs, available since version 24.1, let users simplify complex queries by breaking them into reusable, readable blocks that can be used with SELECT, INSERT, UPDATE, and DELETE statements.
The Limit/Offset feature, added in version 25.1, provides a flexible alternative to the TOP clause, allowing users to limit returned rows and skip specific records, ideal for pagination. Together, these features make queries easier to write, read, and optimize, while the SQL engine automatically handles efficient execution and plan optimization.

Presenters:
🗣 Ismail Ben Atitallah, Principal Systems Developer, InterSystems
🗣 Yiwen Huang, Systems Developer, InterSystems

Enjoy watching, and subscribe for more videos! 👍