Pages

Tuesday 24 November 2015

SQL SERVER ( SUB QUERIES ) REAL TIME INTERVIEW QUESTIONS AND ANSWERS

1. What is sub-query? Explain properties of sub-query?
2. What are the Properties of Sub-Query?
3. What are types of sub-queries?
4. What is a correlated sub-query? How can these queries be useful?
5. How the Exists keyword works in SQL Server?
6. Can we rewrite sub queries into simple select statements or with joins?
7. What is derived table?

No comments:

Post a Comment