Answer Posted / rrrrrrrrrr
The Concept of joining a table with it self in called "self
join"
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What happens if the update subquery returns multiple rows in ms sql server?
Benefits of Stored Procedures?
What are the different types of columns types constraints in the sql server?
Explain nested trigger in sql?
How to get a list of columns in a view using the "sp_help" stored procedure?
What are the different types of lock modes in sql server 2000?
What is difference between views and tables?
Can another user execute your local temporary stored procedures?
How to generate create view script on an existing view?
What are the transaction properties?
How to create median function?
Explain datetime2 data type in sal server 2008?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How do I create a partition table in sql server?
What structure can you implement for the database to speed up table reads?