Clients ayant des paiements, chacun une seule fois

Question

Parmi ces requêtes, lesquelles listent exactement une fois chaque client ayant au moins un paiement, sans DISTINCT ? Choisissez toutes les bonnes réponses.

Answer 1

SELECT c.customer_id, c.last_name FROM customer AS c WHERE EXISTS (SELECT 1 FROM payment AS p WHERE p.customer_id = c.customer_id);

Answer 2

SELECT c.customer_id, c.last_name FROM customer AS c LEFT JOIN payment AS p ON p.customer_id = c.customer_id WHERE p.payment_id IS NOT NULL;

Answer 3

SELECT c.customer_id, c.last_name FROM customer AS c JOIN payment AS p ON p.customer_id = c.customer_id GROUP BY c.customer_id, c.last_name;

Answer 4

SELECT c.customer_id, c.last_name FROM customer AS c WHERE c.customer_id IN (SELECT p.customer_id FROM payment AS p);

Answer 5

SELECT c.customer_id, c.last_name FROM customer AS c JOIN payment AS p ON p.customer_id = c.customer_id;

Answer 6

SELECT c.customer_id, c.last_name FROM customer AS c CROSS JOIN payment AS p WHERE p.customer_id = c.customer_id;

Pratique

Leçons

Playground

Test

Clients ayant des paiements, chacun une seule fois

Se connecter

S'inscrire

Clients ayant des paiements, chacun une seule fois