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
What is merge?
What is the difference between a view and a stored procedure?
What is sql server 2000 work load governor?
Difference between Inner vs outer joins?
What do we need queues in sql service broker?
What is NOT NULL Constraint in sql server 2012?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
How to test odbc dsn connection settings?
How to disable a login name in ms sql server?
What are different types of join?
Does sql server 2000 full-text search support clustering?
What do you mean by table and field in sql?
What is the cpu pressure?
How to add the custom code in Report?
How you can move data or databases between servers and databases in sql server?