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 are the types of stored procedures in an sql server?
How to list all schemas in a database?
What languages bi uses to achieve the goal?
Difference between Logical Page and Physical Page in SSRS.
When to use Inner join & when to use subquery?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
What do you understand by SQL*Net?
What is the difference between stored procedure and user defined functions?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
How to create a user to access a database in ms sql server using "create user" statements?
What are key constraints?
What are out-of-range errors with date and time literals?
How you can find out if an index is useful to the optimizer?
How to delete existing triggers using "drop trigger"?
Why is the need for data conversion transformations?
