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
yogeshyl
Messages: 50
Registered: October 2007
Location: Silvassa
Member
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).

Yogesh
  • Attachment: query.CSV
    (Size: 22.50KB, Downloaded 107 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: 64103
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.

Regards
Michel

Previous Topic: Multiple Selects One Report
Next Topic: I need real examples for Temporary Tables
Goto Forum:
  


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

Total time taken to generate the page: 0.11027 seconds