/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 vote337 views1 answer
Oracle table free space
SQL
0 vote291 views1 answer
Create duplicate table in postgresql
SQL
9 votes337 views2 answers
Sql limit to 5 results
SQL
0 vote314 views1 answer
Check for directory in bash
SQL
4 votes306 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
5 votes336 views1 answer
Mysql created at yesterdau
SQL
1 vote319 views1 answer
Last 6 months postgresql
SQL
0 vote321 views1 answer
This week mysql
SQL
4 votes347 views2 answers
Float postgres
SQL
0 vote317 views1 answer
Casterar postgres
SQL

Share