Does the Sqlite database support the ROW NUMBER () function?

#1 · February 23, 2021, 7:19 am

Hello and good time ...! Does the Sqlite database support the ROW NUMBER () function or not? If it supports! What should it look like?
Thanks & Regards

#2 · February 23, 2021, 1:00 pm

@javadrajabihakami please take a look at this:
https://www.sqlitetutorial.net/sqlite-window-functions/sqlite-row_number/

Regards.

#3 · February 23, 2021, 4:54 pm

Hello and thank you dear friend ...! Good time!
From
SELECT ROW_NUMBER () OVER (ORDER BY name) AS num_row
name,
code
FROM furniture;
I used it but it didn't work at all! Thanks for the tip! thanks again

Does the Sqlite database support the ROW NUMBER () function? - Forum

Does the Sqlite database support the ROW NUMBER () function?