Frage im Vorstellungsgespräch bei Genpact
What is an Inner Join in SQL and give an example query.
Antwort im Vorstellungsgespräch
Anonym
28. Mai 2021
SELECT a.user_id AS user_id, COUNT(1) AS frequency FROM Database1 AS a INNER JOIN Database2 AS q ON a.parent_id = q.id GROUP BY user_id