SQL random data acquisition

I have never noticed random data extraction before. Let's talk about my experience. mssql: select * fromtablenameorderbynewid () desc the function for Obtaining casual data in mssql is newidmysql: select * fromtablenameorderbyrand () desc the rand function for Obtaining casual data in mysql. in this case, I declare that I did not notice the random data extraction before, so I will talk about my experience.

Mssql:

Select * from tablename order by newid () desc

Newid is the function for retrieving casual data in mssql.

Mysql:

Select * from tablename order by rand () desc

The rand function is used to obtain casual data in mysql.

That's simple,

Declaration: Reprinted please note here.