OraFAQ Forum: SQL & PL/SQL » How to select last rate of Product

Home » SQL & PL/SQL » SQL & PL/SQL » How to select last rate of Product (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to select last rate of Product [message #642790]

Sat, 19 September 2015 06:33

manisngpl
Messages: 42
Registered: December 2014
Location: Faisalabad, Pakistan

Member

Dear Member,

I would like to select "last sale rate" which I use during Cash Sale or Credit Sale of each Product to calculate the value of available Stock.

Please help me in the matter.

Regards,

Muhammad Usman

Report message to a moderator

Re: How to select last rate of Product [message #642792 is a reply to message #642790]

Sat, 19 September 2015 06:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

It is a challenge to write SQL when we don't know table or column names.

Report message to a moderator

Re: How to select last rate of Product [message #642794 is a reply to message #642790]

Sat, 19 September 2015 07:14

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

SELECT "last sale rate" FROM <the tables> WHERE <the conditions>

Report message to a moderator

Re: How to select last rate of Product [message #642798 is a reply to message #642794]

Sat, 19 September 2015 16:02

dude4084
Messages: 222
Registered: March 2005
Location: Mux

Senior Member

Michel Cadot wrote on Sat, 19 September 2015 17:14

SELECT "last sale rate" FROM <the tables> WHERE <the conditions>

Report message to a moderator

Re: How to select last rate of Product [message #642827 is a reply to message #642790]

Mon, 21 September 2015 04:47

dude4084
Messages: 222
Registered: March 2005
Location: Mux

Senior Member

manisngpl wrote on Sat, 19 September 2015 16:33

Dear Member,

I would like to select "last sale rate" which I use during Cash Sale or Credit Sale of each Product to calculate the value of available Stock.

Muhammad Usman

Tip: Value of available stock depends upon purchase price, NOT ON SALE PRICE.

Report message to a moderator

Previous Topic:	merge statement (merged :)
Next Topic:	How To Trunc Date In Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 01:28:01 CDT 2024