Write a SQL queries on Self Join and Inner Join.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is b tree index?

0 Answers  


How to fetch the next row from a cursor with a "fetch" statement?

0 Answers  


What's the purpose of Stored Procedure?

6 Answers   Wipro,


What is blocking?

0 Answers  


Explain about SQL server 2005?

0 Answers  






Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,


What are the advantages of log shipping?

0 Answers  


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  


What is hot add cpu in sql server 2008?

0 Answers  


What are joins in sql and what are the different types of joins?

0 Answers  


Which are the third-party tools used in sql server and why would you use them?

0 Answers  


How to optimize stored procedure optimization?

0 Answers  


Categories