第三种，
CALL sp_rownumber('t1',NULL,NULL,NULL);
query result
i_name rank rownum
Lily 7 1
Lucy 2 2
Ytt 14 3
Ytt 14 4
Charlie 12 5
Charlie 13 6
Lily 7 7
Lily 4 8
Ytt 14 9
Lily 6 10
Lucy 1 11
Lily 7 12
Ytt 15 13
Lily 6 14
Charlie 11 15
Charlie 12 16
Lucy 2 17
Charlie 10 18
Lily 5 19
Ytt 15 20