回答編集履歴
1
typo
answer
CHANGED
|
@@ -4,15 +4,15 @@
|
|
|
4
4
|
insert into tbl values
|
|
5
5
|
(1,1,3),
|
|
6
6
|
(2,1,4),
|
|
7
|
-
(3,1,
|
|
7
|
+
(3,1,1),
|
|
8
|
-
(4,1,
|
|
8
|
+
(4,1,2),
|
|
9
|
-
(5,2,
|
|
9
|
+
(5,2,2),
|
|
10
10
|
(6,2,2),
|
|
11
11
|
(7,3,1),
|
|
12
12
|
(8,3,3),
|
|
13
13
|
(9,3,4);
|
|
14
14
|
select * from tbl
|
|
15
|
-
where key1=1 or key2=
|
|
15
|
+
where key1=1 or key2=1
|
|
16
|
-
order by key2=
|
|
16
|
+
order by key2=1 desc,key1
|
|
17
17
|
limit 3
|
|
18
18
|
```
|