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!

SELECT MAX on version fields

TroopersMar 5 2013 — edited Mar 6 2013

Hi,

I have a table A with fields STR_FILENAME, STR_FILEPATH, INT_MAJOR, INT_MINOR, INT_BUILD, INT_REVISION as integer to save a version of files.

How can i get the file with the max version and use this query as subquery to get if a file is the last version?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2013

Added on Mar 5 2013

8 comments

358 views