Answer Posted / ramesh
The Concept of joining a table with it self in called "self
join"
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
How to rebuild all indexes on a single table?
What is compression - row-level and page-level compression?
In what three ways is the return statement used in a stored procedure?
What is replication and database mirroring?
Explain about SQLOS?
How to select an exiting database using mssql_select_db()?
What are the differences between lost updates and uncommitted dependencies?
Explain what are partitioned views and distributed partitioned views?
What are the different kinds of ssrs reports?
What is exporting utility?
Explain cross join or cartesian product in sql?
Which tcp/ip port does the sql server run on? How can it be changed?
How to write character string constants or literals in ms sql server?
What are the steps you can take to avoid “deadlocks”?
Where sql server usernames and passwords are stored in a sql server?