what is joins please explain breffly ??
Answer Posted / sravanthi
The Join keyword is used to query data from 2 or more
tables based on the relationship between the columns in the
table.
1. Join : Returns records when there is atleast one matched
record in both the tables.
2. Left Join : Returns all the records of the left table
irrespective match records in both the tables.
3. Right join : It is just reverse case of left join.
4. Full Join : Returns all the records from both the tables
irrespective matching.
Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
where the connection string store in the database
how you can deploy an ssrs report?
What are filegroups in sql server?
Describe triggers features and limitations?
How to Insert multiple rows with a single insert statement?
How to create and drop temp table in sql server?
How to find index size for each index on table?
How to write a query with a right outer join in ms sql server?
When multiple after triggers are attached to sql table, how to control the order of execution?
What do you understand by intent locks?
When a primary key constraint is included in a table, what other constraints does this imply?
explain what is raid and what are different types of raid configurations? : Sql server database administration
How to provide default values to function parameters?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?