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 a DBMS, query, SQL?
How each E-R model constructs can be mapped to the relational model?
What is right outer join in sql server joins?
What is the difference between char and varchar2 datatype in sql?
What are the different index configurations a table can have?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
What is a data source or ds? : sql server analysis services, ssas
Why normalization is used?
Explain about Views?
What command is used to create a database in the sql server and how?
A trigger can reference objects outside the current database? State true or false.
How do I get to sql server configuration manager?
Can I delete event logs?
How do I connect to sql server database?
What is the importance of three tier architecture?