lundi 12 juillet 2021

Sql Sequelize - Need Random Data with paggination

I need random data from database with paggination. let me explain this.

Example: [ 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 ] above data is in our database.

now I need limit = 3, current page = 1, with random data from database. like in first page data like this [ 2,5,1 ] then second page data never be duplicate.

is there any solution for this?

I used this for random data but not work in pagination. Sequelize.fn( 'RAND' )




Aucun commentaire:

Enregistrer un commentaire