Skip main navigation (Press Enter).
Log in
Toggle navigation
Search Options
Log in
Interest Areas
Financial Systems
Human Capital Management Systems
Student Success
Customer Relationship Management
Connected Campus
Project & Change Management
AI Innovators Network
Public Sector
Strategic Partners
Events
Upcoming Events
Upcoming E-Academy
Education & Training
Alliance 2025
Regional Events
HEUG Europe 2024
HEUG ANZ 2024
Past HEUG Events
Resources
HEUG News
Marketplace
Annual Reports
Online Education Training
Engage
Member Directory
Group Directory
Mentor Program
About
Membership
Board of Directors
Community Council
Global Council
Governance
Hall of Fame
Whistleblower Information
Join
Search Options
PS Query & SQL
×
Community Home
Discussion
169
Library
77
Blogs
0
Members
688
View Only
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
Expanding Your SQL Toolkit: NTH_VALUE for Flattening Student Data
Daniel Labrecque
10 days ago
Understanding SQL window functions can greatly improve how we work with datasets, especially when multiple ...
Robert Fogarty
8 days ago
nth value is very useful ... the key is to properly define the partition. There is no distinct nth value ...
Daniel Labrecque
8 days ago
Robert, Do you think I should add anything to the tutorial? I am open to making changes so everyone ...
Robert Fogarty
8 days ago
incorporating an example would be fantastic ... the difficulty is that we often don't identity that ...
Scott Nishizaki
8 days ago
In my experience, the Key Values of the records are usually the biggest consideration when creating ...
David Ehrlich
8 days ago
...regarding the usage and fixed-nature of output columns of NTH_VALUE... I recently completed ...
Scott Nishizaki
8 days ago
Pardon what may be naivety on my part, but I though that if there was no n value that NTH_VALUE ...
David Ehrlich
8 days ago
NULL is a "special" (non)-value. I played with the SQL in SQLDev. When I check for ...