Interested to Buy Any Domain ? << Click Here >> for more details...
Can we rewrite subqueries into simple select statements or
with joins? Example?
- 2 Answers
- 9178 Views
- ASD Lab, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / divya kalra
Subqueries can often be re-written to use a standard outer
join, resulting in faster performance. As we may know, an
outer join uses the plus sign (+) operator to tell the
database to return all non-matching rows with NULL values.
Hence we combine the outer join with a NULL test in the
WHERE clause to reproduce the result set without using a
sub-query.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / syed sajjad
Yes we can write using Common Table Expression (CTE). A Common Table Expression (CTE) is an expression that can be thought of as a temporary result set which is defined within the execution of a single SQL statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query.
| Is This Answer Correct ? | 1 Yes | 0 No |
How many levels of sp nesting are possible?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
How to view existing indexes on an given table using sys.indexes?
Define Foreign Key?
3 Answers ADP, College School Exams Tests,
What is normalization? Explain its different types?
What is difference between primary key and foreign key?
What is dknf in normalization form?
What are scheduled tasks in sql server?
What command do we use to rename a database?
What is ddl command?
How to edit table in sql server 2017?
What is a non-clustered index?
-
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)
