/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 vote138 views1 answer
Sql server cannot create database diagram
SQL
0 vote138 views1 answer
Create schema sql server
SQL
0 vote150 views2 answers
Generate sql trigger through ef migration
SQL
3 votes141 views2 answers
Postgresql remove not null constraint
SQL
0 vote148 views1 answer
Setval postgres example table id
SQL
-1 vote141 views3 answers
Error mysql shutdown unexpectedly
SQL
0 vote141 views1 answer
Postgresql like
SQL
0 vote191 views1 answer
Store case result sql
SQL
0 vote137 views1 answer
Sql string length postgresql
SQL
1 vote176 views1 answer
Mysql default port
SQL

Share