How many types of Joins in SQL Server 2005?
Answer Posted / mpg
There are 5 types of join in sql server 2005
inner join
outer join
cross join
equi join
self join
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
Can group by be used without aggregate functions?
How can I check that whether automatic statistic update is enabled or not?
How to set a database state to offline in ms sql server?
Can group functions be mixed with non-group selection fields in ms sql server?
What encryption security is available in sql azure?
How can we rewrite sub-queries into simple select statements or with joins?
How to compare the top two records using sql?
What is attribute hierarchy? : sql server analysis services, ssas
What is the difference between varchar and nvarchar?
How to add a new dsn with the odbc driver for sql server?
What is normalization of database?
Can We Use Data-grids For Our Report In Ssrs?
what is the difference between delete table and truncate table commands? : Sql server database administration
Where sql server usernames and passwords are stored in a sql server?
Indexes are updated automatically is the full-text index also updated automatically?