Interested to Buy Any Domain ? << Click Here >> for more details...
what is joins please explain breffly ??
- 1 Answers
- 5039 Views
- Adaequare, TCS, I also Faced
- E-Mail Answers
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 the standby server?
Which are ddl commands?
Explain what is dbcc?
Explain what are page splits? : SQL Server Architecture
What is meant by referential integrity?
How to delete a login name in ms sql server?
what data regions are and what are the different data regions?
Write a sql query to delete duplicate records from a table called table1
What is the chart in report?
How to integrate the ssrs reports in application?
What is an indice?
What are rows and columns?
What stored by the master? : sql server database administration
How will you decide the active and passive nodes?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
