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 ? | 3 Yes | 1 No |
Post New Answer View All Answers
Can we insert data in view?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What are the different types of constraints?
What are sql commands?
explain what is mysql? : Sql dba
Is vs as in pl sql?
What is Histogram?
Is sql a case sensitive language?
How do you update a sql procedure?
How to get help at the sql prompt?
What are the different types of dbmss?
What does desc stand for?
What is left join in sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
Explain spool.