Home » SQL & PL/SQL » SQL & PL/SQL » looking for records with newest dates (merged)
looking for records with newest dates (merged) [message #355228] Thu, 23 October 2008 03:32 Go to next message
marcys
Messages: 2
Registered: October 2008
Location: Poland
Junior Member
Hello

I've got problem with query Sad - I need to find only 'fresh' records with newest date. The table looks like this:

ID Price Material_No Date

New prices are INSERTed into the table - I need the list of material nos. with last valid price

Please give me any advice

Thanks and regards
looking for records with newest dates [message #355230 is a reply to message #355228] Thu, 23 October 2008 03:32 Go to previous messageGo to next message
marcys
Messages: 2
Registered: October 2008
Location: Poland
Junior Member
Hello

I've got problem with query Sad - I need to find only 'fresh' records with newest date. The table looks like this:

ID Price Material_No Date

New prices are INSERTed into the table - I need the list of material nos. with last valid price

Please give me any advice

Thanks and regards
Re: looking for records with newest dates [message #355233 is a reply to message #355230] Thu, 23 October 2008 03:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post what you already tried.
Use SQL*Plus and copy and paste your session.

Before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel
Re: looking for records with newest dates [message #355236 is a reply to message #355228] Thu, 23 October 2008 03:42 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post what you already tried.
Use SQL*Plus and copy and paste your session.

Before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: OCI-21500: internal error code
Next Topic: find names form the table
Goto Forum:
  


Current Time: Sat Dec 10 08:55:28 CST 2016

Total time taken to generate the page: 0.07641 seconds