Interested to Buy Any Domain ? << Click Here >> for more details...
what is joins please explain breffly ??
- 1 Answers
- 5192 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
How many databases instances are there in sql server 2000?
How many types of objects are there?
How to insert data with null values?
What is an identity?
Differentiate between a local and a global temporary table?
What is the return type of executeupdate ()?
What do you do in data exploration
What number sorts of privileges are accessible in sql?
What is a covered index?
What do you mean by 'normalization'?
what is isolation level at dead lock?
Do I need a report server to run reports in my application?
What is the full form of dql?
what protocol both networks use? : Sql server database administration
How you can change the database name in SQL SERVER?
