In which situation you use Self joins?
We use Self Join, if we have a table that references itself.
For example, In the Employee Table below MANAGERID column
references EMPLOYEEID column. So the table is said to
referencing itself.This is the right scenario where we can
use Self Join.
Is This Answer Correct ? | 8 Yes | 0 No |
Define model database?
What is analysis service repository?
How to execute the cursor queries with "open" statements?
Name three version of sql server 2000 and also their differences?
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?
What is use of @@ spid in sql server?
What are different types of schemas?
What is Primary key and foreign key? Give an example
Explain partitioned view?
Explain in brief how sql server enhances scalability of the database system?
Tell me what do you understand by a view? What does the with check option clause for a view do?
plz send every query in sql server2000