Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mohsin mohammed abdul
basically we use joins to query a sql with 1 or more tables.
1) self join.. join within the same table using aliases
2) equi join.. join between the 2 tables with commom columns
3) outer join.. and it is divided into 2 catagories left
outer join and right outer join.
View :- its a logical representation of one or more tables.
View doesn't have the data of its own. But still you can
perform DML on a view ..the changes will be done in the
underlying base tables..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is apply operator in sql?
What are the requirements on sql server network connections?
What is the difference function and stored procedure?
Write a query for primary key constraint with identity key word?
Does group by or order by come first?
What is transaction server consistency?
What is normalization? What number of normalization shapes are there?
Why union all is faster than union?
Explain concepts of analysis services?
What is normalization? Describe its different types.
What are cursors and when they are useful?
What happens when transaction log is full?
How to find out the list schema name and table name for the database?
What is dimension table? : sql server analysis services, ssas
What is the Main Difference between ACCESS and SQL SERVER?
