/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 vote159 views1 answer
Time data type in mysql
SQL
0 vote139 views1 answer
Install sql server in ubuntu 20.04
SQL
2 votes133 views1 answer
Sqlite show table indexes
SQL
0 vote162 views2 answers
Mysql show foreign keys
SQL
6 votes160 views1 answer
To count number of rows in SQL table
SQL
2 votes146 views1 answer
Sql string_agg
SQL
0 vote139 views1 answer
How to print some string in mysql
SQL
6 votes142 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote134 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
1 vote123 views1 answer
Oracle truncate partition
SQL

Share