Rank over () / row_number over in sqlite

[jojoba20]

hi I can i use "rank() over" OR "row_number" in sqlite ? Thanks in advanced!

[Mycroft Holmes]

Did it even occur to you to type that into google[^], it seems to have been answered many time in great detail and 1 looks like it has a work around!

Never underestimate the power of human stupidity RAH

[jojoba20]

i have googled a lot but no good solution ! can give samll example ? thanks in advanced