/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 vote209 views1 answer
Create a plsql object
SQL
24 votes179 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote205 views1 answer
Example of sql querry result sepapreted by comma
SQL
1 vote206 views1 answer
Md5 encryption for existing records
SQL
1 vote204 views1 answer
Sql server list locks
SQL
22 votes226 views3 answers
How to join three tables in sql using joins
SQL
5 votes261 views1 answer
Oracle source query
SQL
0 vote190 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
3 votes205 views1 answer
Oracle revoke grant
SQL
0 vote203 views1 answer
Heidisql check how much space a row
SQL

Share