Home » SQL & PL/SQL » SQL & PL/SQL » Display rows according to specific conditions in resultset (Oracle10g)
Display rows according to specific conditions in resultset [message #361556] Wed, 26 November 2008 23:39 Go to next message
Messages: 50
Registered: October 2007
Location: Silvassa
I had written a query in which the output is the stock ledger of an item ABC. The row marked in red colour gives the actual balance quantity and value after the transactions like opening, receipt & issue.

The column RI denotes the receipt & issue transaction.

I want to display only the row for the actual balance qty & value (marked in red).

  • Attachment: query.CSV
    (Size: 22.50KB, Downloaded 116 times)
Re: Display rows according to specific conditions in resultset [message #361558 is a reply to message #361556] Wed, 26 November 2008 23:44 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From your previous post:
Michel Cadot wrote on Thu, 24 July 2008 07:54
Don't attach it, some of us can't download it, post it inline but 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).

Post a test case: create table and insert statements along with the result you want with these data.

Post what you already tried.


Previous Topic: Howto Initialize collection containing collection?
Next Topic: Date Bug in Oracle ?
Goto Forum:

Current Time: Sat Aug 19 13:55:31 CDT 2017

Total time taken to generate the page: 0.06565 seconds