Breaking News: Grepper is joining You.com. Read the official announcement!

Partition to find most recent entry in data set.

Naughty Newt answered on August 5, 2022 Popularity 1/10 Helpfulness 1/10

answer Partition to find most recent entry in data set.

Partition to find most recent entry in data set.

Comment

SELECT 
           UID, FULL_NAME, EVENT_TIME
      FROM (
        SELECT  UID,
                FULL_NAME,
                EVENT_TIME,
                row_number() OVER (PARTITION BY OEL_UID ORDER BY EVENT_TIME DESC) AS rn
       FROM OWNER.TABLE
    ) 
    WHERE rn = 1
    ORDER BY UID) U ON S.UID = U.UID

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: find partition sql

Link to this answer
Share Copy Link

Contributed on Aug 05 2022

Naughty Newt

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Partition to find most recent entry in data set.

Contents

More Related Answers

Partition to find most recent entry in data set.

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.