What are different types of joins ?

Answer Posted / t.rajesh gupta

Different types of joins are 1.self join, 2. Equi join, 3.
non-equi join 4. cross join

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write a sql query to get the third highest salary of an employee from employee_table?

632


How to run sql*plus commands in sql developer?

589


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

500


Explain the steps needed to create the scheduled job?

557


How many columns should be in an index?

518






What does select * from mean in sql?

1986


which command using query analyzer will give you the version of sql server and operating system? : Sql dba

522


What is linq to sql?

550


what is a constraint? Tell me about its various levels. : Sql dba

561


Which version of sql do I have?

558


What is difference between sql and mysql?

529


Write a query to find the names of users that begin with "um" in sql?

501


What are field types?

535


What are the advantages of sql? Explain

648


What are literals in sql server?

528