teratail header banner
teratail header banner
質問するログイン新規登録

回答編集履歴

2

typo\.

2015/12/21 10:14

投稿

hyper-drums-ko
hyper-drums-ko

スコア736

answer CHANGED
@@ -7,8 +7,8 @@
7
7
  @category := category as dummy_field
8
8
  from Table1, (select @rank := 0, @category := 0) as dummy_table
9
9
  order by category, point desc
10
- ) as table
10
+ ) as t
11
- where table.rank <= 2
11
+ where t.rank <= 2
12
12
  order by category, point desc
13
13
  ```
14
14
  こんな感じでしょうか?

1

typo\.

2015/12/21 10:14

投稿

hyper-drums-ko
hyper-drums-ko

スコア736

answer CHANGED
@@ -4,11 +4,11 @@
4
4
  (
5
5
  select *,
6
6
  @rank := if (@category = category, @rank + 1, 1) as rank,
7
- @category := category as dummy
7
+ @category := category as dummy_field
8
- from test, (select @rank := 0, @category := 0) as dummy
8
+ from Table1, (select @rank := 0, @category := 0) as dummy_table
9
9
  order by category, point desc
10
- ) as x
10
+ ) as table
11
- where x.rank <= 2
11
+ where table.rank <= 2
12
12
  order by category, point desc
13
13
  ```
14
14
  こんな感じでしょうか?