/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 vote128 views1 answer
Mysql 8 geo to json
SQL
-2 votes131 views1 answer
Create trigger syntax
SQL
0 vote128 views1 answer
Mysql changer nom table
SQL
1 vote140 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
16 votes143 views1 answer
Mysql smallint range
SQL
1 vote120 views1 answer
Last 6 months postgresql
SQL
0 vote121 views1 answer
Mysql multiple group by
SQL
4 votes120 views1 answer
Oracle show error line number
SQL
6 votes125 views3 answers
Oracle all dates between two dates
SQL
1 vote147 views1 answer
Oracle select row max date
SQL

Share