/SQL/Select random sql

Select random sql

Select random sample sql

 Using a SAMPLE clause, we can select random rows.
SELECT * FROM table_name SAMPLE(10);

1

Select random sql

SELECT column FROM table ORDER BY RAND() LIMIT 1

0

Select random sql

SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1

-1

Source: stackoverflow.com

Similar codes

0 vote182 views1 answer
Dump only schema
SQL
8 votes203 views1 answer
See all users mysql
SQL
2 votes204 views1 answer
Sql OR
SQL
6 votes199 views2 answers
Clear a table in mysql
SQL
19 votes197 views2 answers
Mysql tinyint max value
SQL
1 vote161 views1 answer
Insert into sql
SQL
-1 vote206 views1 answer
Can pandas fetch data from sql
SQL
0 vote213 views1 answer
Print boolean in plsql
SQL
1 vote195 views3 answers
How to update column name in psql
SQL
0 vote242 views1 answer
Sparql list all graphs
SQL

Share