Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alternative solution to Teradata qualify row_number over(partition by, order by) = 1

user11991336Aug 20 2018 — edited Aug 20 2018

Hello,

     we're migrating a lot of  teradata code to oracle. One code that is used a lot is the syntax qualify. I know this can be resolved by using a subquery using row_number as part of the subquery and then = 1 in the main query. Is there an alternative solution that doesn't use a subquery and get the same results and is efficient? I was hoping there is another way to shorten the code. Thank you in advance.

This post has been answered by mathguy on Aug 20 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2018
Added on Aug 20 2018
2 comments
4,280 views