您最多选择25个主题 主题必须以字母或数字开头,可以包含连字符 (-),并且长度不得超过35个字符

12345678910
  1. SELECT
  2. p1.product_name, p1.list_price
  3. FROM
  4. products p1
  5. JOIN
  6. products p2 ON p1.product_id != p2.product_id
  7. AND p1.list_price = p2.list_price
  8. WHERE
  9. p1.list_price = p2.list_price
  10. ORDER BY p1.product_name ASC;