Answer Posted / prasanna
Inner joins use a comparison operator(like = or <>)to match
rows from two tables based on the values in common columns
from each table.It is a default type of join.
These includes Equi Joins and Natural Joins.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Difference between report and query parameter. Why do we need different type of parameter?
What is the significance of null value and why should we avoid permitting null values?
Explain a checkpoint?
Can we join two tables without primary key?
How to replace the Query Result 'Null Value' with a text ?
explain different types of cursors? : Sql server database administration
What is difference between oltp and olap?
Name three of the features managed by the surface area configuration tool? : sql server security
Define synonym?
Explain intellisense for query editing
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What is scrollable cursor?
what are the core components of SSRS?
What is the difference between local and global temporary tables?
What is the Difference Between Primary and Foreign Key?