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
No Answer is Posted For this Question
Be the First to Post Answer
Explain the the delete statements in sql?
What is the use of count (*) in sql?
What are the steps you take to tune(performance tuning) the code in plsql?
4 Answers Cap Gemini, Infosys, TCS,
How will you make performance better for application including front end and back
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What is delete command in sql?
Mention what does the hierarchical profiler does?
What is the difference between sql and t sql?
what is a record in a database ? : Sql dba
Is sql microsoft?
Why do we use procedures in pl sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)