SQL Language (MOSC)

MOSC Banner

last record for each inventory_item_id

edited Dec 7, 2019 4:01AM in SQL Language (MOSC) 6 commentsAnswered

inventory_item_id    value

1                                3

1                               3.2

1                               4 -- last record for 1

2                              10

2                             15 -- last record for 2

3                             98

3                           120-- last record for 3

output

1   4

2   15

3   120

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center