Shulou(Shulou.com)06/02 Report--

This article mainly explains the "SQL random extraction of N rows of data implementation method", the content of the article is simple and clear, easy to learn and understand, now please follow the editor's ideas slowly in depth, together to study and learn "SQL random extraction of N rows of data implementation method"!

This article will show you how to randomly extract the first N pieces of data from the data.

Sample data

The current data is shown in the following table:

Empnoenamejobsal7369SMITHCLERK800.07876SMITHCLERK1100.07900JAMESCLERK950.07934MILLERCLERK1300.07499ALLENSALESMAN1600.07654MARTINSALESMAN1250.07844TURNERSALESMAN1500.07521WARDSALESMAN1250.0 implementation method

Through order by rand () to achieve the effect of random extraction.

SELECT empno, ename, sal, job FROM emporder by rand () limit 3

Thank you for your reading, the above is the content of "the realization method of randomly selecting N rows of data by SQL". After the study of this article, I believe you have a deeper understanding of the realization method of randomly selecting N rows of data by SQL, and the specific use still needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.