Answer Posted / roopesh kumar
(1) Inner or Equei join
(2) Outer or no - equei join
(a) left outer
(b) right outer
(c) full outer
(3) Cartision or cross join
(4) Self join
(5) Natural join
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do I make my sql query run faster?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is numeric function sql?
What are the steps for performance tuning.
How do I find sql profiler?
Does sql backup shrink transaction log?
Explain the rollback statement?
What is a nested table in word?
What is the use of triggers?
What is pl/sql table? Why is it used?
How do I delete a trigger?
What is cte?
what is index? : Sql dba
What is difference between table and view?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5