adspace


what is a correlated sub-query? : Sql server database administration

Answer Posted / Praveen Singh Yadav

A correlated sub-query is a sub-query that depends on values from the main query, meaning it can access variables and tables defined in the main query.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can sql servers link to other servers like oracle?

928


what is spatial nonclustered index

1066


If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1051


What is subquery? Explain the properties of a subquery?

1070


Why should you use or avoid select * statements?

1120


How to rebuild the master database?

1175


Why we use the openxml clause?

1088


What are wait types?

1260


How to remove duplicate rows from table except one?

1096


What are the different SQL Server Versions you have worked on?

1084


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8237


What is sql server query analyzer?

1136


What kind of problems occurs if we do not implement proper locking strategy?

1508


How do I find query history in sql server?

1033


How can you append an identity column to a temporary table?

1076