Answer Posted / sandhya
JOINING TO TABLE ITSELF IS CALLED SELF JOIN. HERE WE ARE USING THE SAME TABLE WITH DIFFERENT ALIYAS'S.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is sql server 2000 work load governor?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What are the advantages of log shipping?
In which format does an image save in SQL Server database ?
What is Federation and Federation Member?
What is the usage of sign function?
What are the kinds of subquery?
Can you explain full-text query in sql server?
Can group by and orderby be used together?
What is the recursive stored procedure in sql server?
Give a example to search fr a string in all stored procedure in sql server.
What are the authentication modes in sql server? How can it be changed?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
which backup strategy you are following at ur company