In SQL, what is a subquery?
- A query nested within another query
- A query that returns aggregate data
- A query used to create a new table
- A query used to update records
A subquery in SQL, also known as a nested query or inner query, is a query nested within another SQL query. It is enclosed within parentheses and is executed first before the outer query. Subqueries are often used to retrieve data based on a condition or calculation from another table.
Loading...
Related Quiz
- The SQL ____________ statement is used to validate the uniqueness of values in a column.
- In load testing, what is the typical approach to evaluate system performance?
- What is one way to prevent SQL injection attacks in your applications?
- Scenario: While performing database performance testing, you notice that query response times vary significantly under different loads. What could be the underlying challenges causing this?
- Which phase of the SDLC (Software Development Life Cycle) typically includes database testing?