How many types of Joins in SQL Server 2005?
Answer Posted / prasanna
1.Inner Join
- Equi Join
- Natural Join
2.Outer Join
- Left Outer Join Or Left Join
- Right Outer Join Or Right Join
- Full Outer Join Or Full Join
3.Cross Join
4.Self Join
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is difference between views and stored procedures?
What are the reporting services components?
How to make conditional sum in ssrs?
Which table keeps the locking information?
What is difference between rollback immediate and with no_wait during alter database?
What is the default Port No on which SQL Server listens?
how to overcome kernel isssues
List the different normalization forms?
How do you size a resultset?
what are the different ways to return the rowcount of a table?
Do you know what is rank function?
In which files does sql server actually store data?
Explain how to send email from sql database?
What is the difference between for trigger and after trigger?
Does windows server 2016 come with sql server?