Interested to Buy Any Domain ? << Click Here >> for more details...
What is the disadvantage of using subquery exact after a
select statement?ex.
select (select * from sometable)
- 1 Answers
- 11972 Views
- I also Faced
- E-Mail Answers
Answer Posted / sandeep
Main difference is the outer and inner querries are
independent each other. This executes inner querry for each
and every rows in outer querry. It is better to use joins
instead of sub querries where it is possible. But in some
cases we cud use subquerries
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What xml support does the sql server extend?
Explain magic tables in sql server?
What is always encrypted?
Which joins are sql server default?
How to sort query output in descending order in ms sql server?
How to backup SQL Server Reporting Services ?
Explain query editor regions
What are binary string data types in ms sql server?
What are the extra roles available in msdb? : sql server security
if no size is defined while creating the database, what size will the database have? : Sql server administration
What are the advantages of partitioning?
What is 4nf in normalization form?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Explain the difference between cross join and full outer join?
How to delete duplicate rows from table except one?
