What are the type of joins? When do we use Outer and Self joins?
Answer Posted / shivanibehere
http://www.tomjewett.com/dbdesign/dbdesign.php?
page=jointypes.php&imgsize=medium
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I make a resultset scrollable?
What is data source object?
How to sort query output in descending order in ms sql server?
which table keeps the locking information? : Sql server administration
What are binary string data types in ms sql server?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What is the impact on other user sessions when creating indexes?
How to create user defined functions with parameters?
what are the different ways to return the rowcount of a table?
What does man by sql wildcard characters in sql server?
Can we use pragma autonomous_transaction in trigger?
What do we need queues in sql service broker?
what is database replication? : Sql server database administration
What is the difference between the application object and session object?
What is bit data type?