Home » SQL & PL/SQL » SQL & PL/SQL » Select The Max year and their Month (Oracle 9i, Forms and Reports 6i)
Select The Max year and their Month [message #340762] Thu, 14 August 2008 03:40 Go to next message
cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA
Senior Member

Hai,

I Need to Select the Last Stock War Rate From the Month Stock Ledger. where i have month number and year number.
Please give the solution to select last war rate in the Month Stock Ledger


Ex:

MTHNO      YRNO   MATLCODE    Rate
5          2007  710301043    25.1
9          2007  710301043    24.6
3          2008  710301043    26.5


They were select the last Receipt month stock details.

Please reply me immediatly.
Re: Select The Max year and their Month [message #340766 is a reply to message #340762] Thu, 14 August 2008 03:50 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
cvs_1984 wrote on Thu, 14 August 2008 10:40

Please reply me immediatly.


phew. just in time..

Re: Select The Max year and their Month [message #340779 is a reply to message #340762] Thu, 14 August 2008 04:44 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Please reply me immediatly.

A good way to shut me up.

Please read OraFAQ Forum Guide immediatly.

Regards
Michel


Previous Topic: How many times a user has been logged in on a particular day?
Next Topic: Execption handling
Goto Forum:
  


Current Time: Sat Dec 03 07:45:40 CST 2016

Total time taken to generate the page: 0.15114 seconds