DistillPrep
Python
GenAI
GenAI Frameworks
NLP
Deep Learning
Machine Learning
ML Libraries
Statistics
SQL
MLOps
Cloud
System Design
Blog
Learn
Practice
Test
Live Engine
Select Topic
SQL Fundamentals
(15)
Filtering And Conditions
(15)
Joins And Set Operations
(15)
Aggregation And Groupby
(15)
Window Functions
(15)
Subqueries And Ctes
(15)
String And Date Functions
(15)
Indexing
(15)
Query Optimization
(15)
Transactions And Acid
(15)
Database Design And Normalization
(15)
Nosql Vs SQL
(15)
SQL For Data Science
(15)
easy
Subqueries And Ctes
A developer writes a subquery to find employees earning above the company average. Which query is a non-correlated subquery?
A
Query A — the subquery references no columns from the outer query and executes once
B
Query B — the subquery is correlated and executes once per outer row
C
Both are non-correlated — they both use AVG(salary)
D
Both are correlated — they both reference the
employees
table
Previous
Back
Next