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
How will you add a dimension to cube? : sql server analysis services, ssas
Explain syntax for dropping triggers?
What do you mean by sql server 2005 express management tools?
Do you know what are pages and extents? : SQL Server Architecture
Explain logical operators in sql server?
What are the advantages of user-defined functions over stored procedures in sql server?
Is null vs coalesce?
What are types of scd? : sql server analysis services, ssas
Explain Geography datatype in SQL Server
What are the disadvantages of using querystrings to send data from one page to another?
What is the difference between mysql and mysqli?
When do you think a developer should use sql server-based cursors?
How to perform key word search in tables?
Why do we use trigger?
Can you explain the disadvantages/limitation of the cursor?