我有下表，称为sales
+--------+--------+
| fruit | amount |
+--------+--------+
| cherry | 124 |
| plum | 23 |
| pear | 19 |
| apple | 13 |
| banana | 4 |
| orange | 2 |
+--------+--------+
并用它来获得排名
SET @rank=0;
SELECT @rank:=@rank+1 AS rank, fruit, amount FROM sales ORDER BY amount DESC;
.
+------+--------+--------+
| rank | fruit | amount |
+------+--------+--------+
| 1 | cherry | 124 |
| 2 | plum | 23 |
| 3 | pear | 19 |
| 4 | apple | 13 |
| 5 | banana | 4 |
| 6 | orange | 2 |
+------+--------+--------+
所以现在我想获得的排名，apple但我不知道该怎么做。