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
- 11971 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 |
Can we create nonclustered index in a table without creating a clustered index
What is index in an assignment?
Explain Geography datatype in SQL Server
Write an sql query to find the names of employees start with ‘a’?
What does it mean to invest in the index?
What is a domain constraint give an example?
What are statistics?
What are the different types of replication? How are they used?
How much does sql server 2016 cost?
Explain system rowset functions?
how can you move the master database
How to make remote connection in database?
-
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)
