Answer Posted / dinesh rathod
Self join is just like any other join, except that two instances of the same table will be joined in the query
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the bookmark lookup and rid lookup?
What is a data collection table?
How would we use distinct statement? What is its use?
What are the features of Embedded SQL
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is a unique index?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What are sub reports?
on line cluster can we make if yes tell me the procedure
How to convert numeric values to integers in ms sql server?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What is row_number()?
What is the difference between left and right outer join?
How you can change a cross join into an inner join?
How to replace given values with null using nullif()?