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 to get a list of columns in a view using the "sp_columns" stored procedure?
What is report snapshot in ssrs?
What is scalar user-defined function?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
How to create a scrollable cursor with the scroll option?
What is the default schema of your login session in ms sql server?
What are a database and a data warehouse?
What is the boxing and unboxing concept in .net?
What is recompile sql server?
Can primary key be null?
What is sqlcmd?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What is logon trigger?
What is autocommit mode in sql server?