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
- 11951 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
How to list all dsn entries on your local machine using odbc_data_source()?
What is a View ? Can we insert, Update and delete a view?
What is user-defined scalar function?
How you can find out if an index is useful to the optimizer?
What are the grouping functions?
How you can change the database name in SQL SERVER?
Explain how dts is used to extract, transform and consolidate data?
What are xml indexes?
do views contain data ?
What do you mean by acid?
What are a scheduled jobs?
Can coalesce return null?
What is table level trigger?
What is data block and how to define data block size?
How to get the definition of a stored procedure back?
