0

Here is my query.

SELECT ROW_NUMBER() OVER(ORDER BY RANDOM()) AS rowNo, id, name, address FROM Users

It works in Sqlite Db Browser. Is there any other way to put rowNo on randomize rows?

My Users table

id | integer, auto-increment
name | text
address | text
Improve this question
2
  • welcome ...add your db structure and script with error . Commented Jun 22, 2020 at 10:56
  • I found out that Windows Functions requires SQLite 3.25.0 or greater but sqlite bundled with api 28 is 3.19. I solved this by using sqlite included in react-native-sqlite-storage module. Commented Jun 24, 2020 at 3:35
Related questions
1
react-native-sqlite-storage Undefined is not an object (evaluating 'NativeModules["SQLite"][method]')
3
How can I use sqlite with react-native?
4
react native react-native-sqlite-storage not return result
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.