What is meant by Join? What are the different types of
Joins available? Explain.
Answer Posted / dinesh kumar
Joins -- Getting related data from more than one table.
Type:
Inner JOin --Equi Join -- Non Equi join
Outer JOin --LEft Join -- Right Join -- Full Outer JOin
CRoss Join
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql partition function?
Explain the difference between triggers and constraints?
What is a recursive stored procedure?
How many types of cursors are available in pl/sql?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
how to rename an existing table in mysql? : Sql dba
what is transaction? : Sql dba
Write an sql query to select all records from the table?
What are the benefits of stored procedures?
What is the difference between Union and Union all. Which is faster.
How can triggers be used for the table auditing?
What is range partitioning?
Can we rollback truncate?
is mysql query is case sensitive? : Sql dba
Does sqlite need a server?