Article

José Pereira · Nov 26 10m read

Understanding SQL Window Functions (Part 2)

In Part 1, we explored how window functions operate. We learned the logic behind PARTITION BY, ORDER BY, and such functions as ROW_NUMBER() and RANK(). Now, in Part 2, let's delve into more window functions with practical examples.

#Analytics #Performance #SQL #Tools #InterSystems IRIS

3 0

0 19

Discussion

Gabriel Ing · Nov 17

Open Exchange Tools you can't live without

Hi Everyone,

As I'm sure most of you will be aware, we have an excellent resource available to developers in the Open Exchange, which is a place for Community Members to share open source resources, templates, tools and demos built with or for InterSystems technologies. This has been a massive success, with >1100 projects shared!

#Development Environment #Tools #Open Exchange

3 0

1 38

Article

Ashok Kumar T · Nov 4 3m read

Document Database Explorer

Introducing IRIS DocDB Explorer: A Sleek UI for Managing JSON Documents in InterSystems IRIS

IRIS offers a dedicated feature for storing and retrieving JSON documents using DocDB, without requiring a predefined schema.

#CSP #Databases #Document Data Model (NoSQL) #JSON #Tools #HealthShare #InterSystems IRIS #InterSystems IRIS for Health #TrakCare

Open Exchange app

0 0

0 39