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
- 11872 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is correlated subquery in sql server?
What is index, cluster index and nonclustered index?
How can I know what query is executing by by a particural user? (using sp id or any othe way.)
Why olap is used?
Can some one please help with a query which will take only max value of a column in a join.
What is a view and what are its advantages?
What is the contrast amongst drop and truncate?
How do I clean up sql server transaction log?
Why use “in” clause in sql server?
How many partitions a clustered index has by default in sql server 2012?
In what sequence sql statement is processed?
How many types of cursor type are there?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
