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 106 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: 63911
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: Multiple Selects One Report
Next Topic: I need real examples for Temporary Tables
Goto Forum:

Current Time: Sat Oct 22 11:20:40 CDT 2016

Total time taken to generate the page: 0.10370 seconds