Join Practice #10

Join Practice #10

Easy Programming Interview DBMS 21 views
Explanation Complexity

Problem Statement

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.

Input / Output Format

Input Format
SQL tables are described in the question.
Output Format
Write the SQL query.

Example Solution (Public)

Programming Interview 
SELECT a.id
FROM A a
INNER JOIN B b ON b.id=a.id;

Official Solution Code

SELECT a.id
FROM A a
INNER JOIN B b ON b.id=a.id;
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.