Interested to Buy Any Domain ? << Click Here >> for more details...
what is joins please explain breffly ??
- 1 Answers
- 5079 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 thr feature of change data capture?
whats the maximum size of view state??
What is set nocount on and what is set nocount off?
Do you know how to make remote connection in database?
How to generate random numbers with the rand() function in ms sql server?
Do you know what are the properties of the relational tables?
what is a self join? Explain it with an example? : Sql server database administration
Write a program to fetch first 10 records from a file?
What is difference between sql and sql server?
How to get the definition of a user defined function back?
What are the triggers in sql?
What is wrong with sql server client libarary dll, ntwdblib.dll?
What is DCL?
What is a dataset and what are the different types of datasets?
Define primary key?
