Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

a table has 2 classifications
1)liabilities
2)earnings
this liabitity has 2 elements with 2 input values
and
the earnings have 2 elements with 2 input values
i wrote a query so that my input is
liability savings amount1 amount2
xxxx null xxxxxx 0
xxx1 null xxxxx1 0
null yyyy 0 yyyy
null yyy1 0 yyy1
my problem is
--when i developed a report(d2k) with this data
my o/p is
liabilities,amount1,savings,amount2
xxxx xxxxxx
xxx1 xxxxx1
yyyy yyyy
yyy1 yyy1
how could i move this savings,savings values 2 palces up.
can any body provide me witha better solution

Question Posted / guest

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

How do you truncate?

0 Answers  

What are the advantages of the packages

6 Answers   Oracle,

What is the sql*loader? : aql loader

0 Answers  

How do I install microsoft sql?

0 Answers  




what are the advantages and disadvantages of views in a database? : Sql dba

0 Answers  

what is the order of pre-defined exceptions.

6 Answers   TCS,

Store procedure will return a value?

4 Answers   eMids,

Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,

What is nvl?

0 Answers  

Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  

What are the types of index in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories