EXISTS for faster membership

SQL Easy 3 views
Back to Questions
Previous IN subquery filter Easy P Next Subquery in FROM (derived table) Easy N

Problem Description

Find products that have at least one order item.

Input Format

SQL query

Output Format

Result set

Sample Test Case

Input:
Products, OrderItems
Output:
Product list

Constraints

Use EXISTS
Please login to submit solutions and comments.

Solutions (0)

No solutions submitted yet. Be the first!

Discussion (0)

No comments yet. Start the discussion!

Prev Next