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
- 11954 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 |
Is sql server implemented as a service or an application? : Sql server database administration
What is instead of trigger sql server?
what is the difference between openrowset and openquery?
What is the use of sign function?
How you can get the list of largest tables in a database?
Can we use max in where clause?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
How many types of cursor type are there?
What does it mean if @@cursor_row returns a negative number?
What are date and time data types in ms sql server?
How to get the definition of a user defined function back?
What is acid db?
-
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)
