Answer Posted / gagan
Self join correlated rows of a table with other rows in the
same table.
Eg:
select a.name+'issue the book= '+b.book form lib a,lib b
where rollno between 1 and 10
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain system rowset functions?
What is query processing?
How to update values in a table with update statements in ms sql server?
What is sleeping status in sql server?
can SSRS reports Cache results?
Does a server store data?
What is SQL Azure Federations?
Explain transaction server auto commit?
What is the query and subquery?
What is normalization and what are the advantages of it?
What is the cpu pressure?
What is checkpoint process in the sql server?
How do you test your database? : sql server database administration
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas