Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM shop;
- +---------+--------+-------+
- | article | dealer | price |
- +---------+--------+-------+
- | 0001 | A | 3.45 |
- | 0001 | B | 3.99 |
- | 0002 | A | 10.99 |
- | 0003 | B | 1.45 |
- | 0003 | C | 1.69 |
- | 0003 | D | 1.25 |
- | 0004 | D | 19.95 |
- +---------+--------+-------+
- SELECT s1.article, s1.dealer, s1.price
- FROM shop s1
- LEFT JOIN shop s2 ON s1.price < s2.price
- WHERE s2.article IS NULL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement