回答編集履歴
1
訂正
answer
CHANGED
|
@@ -4,10 +4,12 @@
|
|
|
4
4
|
where not exists(
|
|
5
5
|
select 1 from products p where p.id > products.id and p.name=products.name
|
|
6
6
|
)
|
|
7
|
+
and (
|
|
7
|
-
|
|
8
|
+
(name = 検索値段１ and date >= 検索日付１)
|
|
8
9
|
OR (name = 検索値段２ and date >= 検索日付２)
|
|
9
10
|
OR (name = 検索値段３ and date >= 検索日付３)
|
|
10
11
|
・
|
|
11
12
|
・
|
|
12
13
|
・
|
|
14
|
+
)
|
|
13
15
|
```
|