Join Practice #40
Programming Interview
Easy
6 views
Problem Description
Tables: A(id, val), B(id, val). Return ids present in both tables.
Input Format
SQL tables are described in the question.
Output Format
Write the SQL query.
Official Solution
SELECT a.id
FROM A a
INNER JOIN B b ON b.id=a.id;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!