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 does nvl stand for?
What are system databases into sql server (2005/2008)?
How to execute a sql statement using odbc_exec()?
What are the options which must be set to allow the usage of optimistic models?
What is constraints and its types?
How can we get count of the number of records in a table?
What are data resources?
Do you know what is a trace frag? Where do we use it?
What is a select query statement in ms sql server?
What are the types of processing and explain each? : sql server analysis services, ssas
What is page in sql server?
How do you rename a table in sql server?
Explain about Views?
Does an index slow down updates on indexed columns?
How to reaname table name without using sp_Rename in sql server..?
