Display rows according to specific conditions in resultset [message #361556] |
Wed, 26 November 2008 23:39  |
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 587 times)
|
|
|
Re: Display rows according to specific conditions in resultset [message #361558 is a reply to message #361556] |
Wed, 26 November 2008 23:44  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
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
|
|
|