/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 vote225 views1 answer
Find usage of table in sql server
SQL
0 vote211 views1 answer
Drop all tables db2
SQL
0 vote208 views1 answer
Show all mongodb
SQL
0 vote231 views2 answers
Reseed sql identity
SQL
0 vote211 views1 answer
Select insert new table sql server
SQL
2 votes232 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote226 views2 answers
Sqlalchemy core in clause
SQL
1 vote226 views1 answer
Oracle schema size
SQL
1 vote222 views1 answer
How to select rows with no matching entry in another table?
SQL
3 votes213 views2 answers
Sqlite show table definition
SQL

Share