what are the different types of joins?
Answer Posted / a.jyothsna
1)Self Join
2)Equi join (or)Inner Join
2.1)Non-equi Join
3)Outer Join
3.1) Left-Outer Join
3.2) Right-Outer Join
3.3) Full-Outer Join
Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
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
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is fmtonly in sql?
What are the different parts of a package?
explain what is mysql? : Sql dba
What is the difference between subquery and correlated query?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
explain normalization concept? : Sql dba
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is bind reference and how can it be created?
What is $$ in sql?
How do you get column names only for a table (sql server)?
what is a database lock ? : Sql dba
What is sql*plus?
Why commit is not used in triggers?