SQLite random n rows of data

I have been using SQLite under wince for more than two years. I have also experienced two projects and deeply lamented the efficiency of SQLite.

Queries and deletions are almost identical to those used on PCs.

Today, I have studied the problem of random data retrieval. Another shock is that SQLite really has everything to offer.

The statement is as follows:

Select * from table name order by random () limit 1

Of course, you can insert where in the middle to filter your data.

After a trial, a random query is performed on a table with more than 20 pieces of data. The results are different each time.