/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

1 vote270 views1 answer
Error code 1055
SQL
0 vote243 views1 answer
Deleted table in sql trigger
SQL
3 votes269 views1 answer
Oracle apex warning message
SQL
0 vote264 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote255 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
1 vote270 views1 answer
Sql server get users
SQL
1 vote292 views1 answer
Psql filed name alter
SQL
4 votes272 views1 answer
Force drop all tables postgres
SQL
3 votes276 views1 answer
Oracle revoke grant
SQL
0 vote258 views1 answer
Check if a word appears at the end sql query
SQL

Share