/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 vote264 views1 answer
Find number of entries sql
SQL
28 votes234 views6 answers
Distinct sql
SQL
5 votes262 views1 answer
Oracle sysdate
SQL
0 vote302 views1 answer
Sql quary intervewi question
SQL
0 vote302 views1 answer
Delete hangfire retries list
SQL
0 vote281 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
2 votes274 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote274 views1 answer
Do you know sql
SQL
0 vote224 views2 answers
How to combine two sql queries in one result
SQL
1 vote263 views2 answers
Mysql current user
SQL

Share