For the joins you can go for this link ---- http://www.databasejournal.com

What are the type of joins? When do we use Outer and Self joins?

Question Posted / shivanibehere

Answer Posted / shivanibehere

For the joins you can go for this link ----
http://www.databasejournal.com/features/oracle/article.php/3
527921

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Do you know query execution plan?

1179

What is the use of “join” in sql server?

1096

Is it important for a database administrator to understand the operating system and file access?

996

write an SQL query to list the employees who joined in the month of January?

1677

Explain different types of locks in sql server.

1080

List all the types of user-defined functions?

1102

Why truncate is ddl?

1089

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

984

What are the different types of subquery?

1160

Does an index slow down updates on indexed columns?

974

List some advantages and disadvantages of stored procedure?

1016

What is the difference between createstatement and preparedstatement?

942

in the physical file layout, where should the transaction log be stored in relation to the data file?

994

What are the restrictions that views have to follow? : SQL Server Architecture

1001

what are the core components of SSRS?

129