Search the row number un SQLITE

Asked Nov 02 '17 at 13:00

Active Nov 02 '17 at 17:12

Viewed 59 times

I'm using SQLITE (so no row_number)

Here is my database call : tableau

ID | Nom  | Score
---|------|------
1  | Clem | 50
2  | Caro | 60
3  | Flo  | 55

I'm using:

SELECT * FROM tableau ORDER BY Score DESC

And here is what I get:

ID | Nom  | Score
---|------|------
2  | Caro | 60
3  | Flo  | 55
1  | Clem | 50

But I would like to get the Row number of 'Flo" after its sorted in descending order

But I don't know how to do it...

edited Nov 02 '17 at 16:44

asked Nov 02 '17 at 13:00

clement pignet

`SELECT * FROM tableau ORDER BY Score DESC **WHERE** Nom = 'Flo';` Can you try above query ? – Mahesh Karia Nov 02 '17 at 13:09
I edited my post, I need the row number when order by Score, but not all the data of 'Flo' – clement pignet Nov 02 '17 at 16:45
`SELECT ID FROM tableau ORDER BY Score DESC **WHERE** Nom = 'Flo'; ` I hope this works for you. – Mahesh Karia Nov 02 '17 at 16:57

0 Answers0