Wed 12 Apr 2006
Analytic Functions
Posted by Shane under SQL Tricks
I always seem to get this wrong, so please excuse this note to myself.
SELECT gpa,
DENSE_RANK() OVER (PARTITION BY strm, class_nbr ORDER BY gpa DESC) class_rank
Wed 12 Apr 2006
Posted by Shane under SQL Tricks
I always seem to get this wrong, so please excuse this note to myself.
SELECT gpa,
DENSE_RANK() OVER (PARTITION BY strm, class_nbr ORDER BY gpa DESC) class_rank