/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

3 votes362 views1 answer
Sql online test questions and answers
SQL
0 vote357 views1 answer
Postgresql on conflict pair
SQL
13 votes334 views4 answers
Mysql get last row
SQL
0 vote358 views2 answers
Select columns from 2 tables with foreign key
SQL
2 votes305 views1 answer
Mysql admin u root p password change password
SQL
0 vote352 views1 answer
Sql get month from date
SQL
0 vote341 views1 answer
Mysql workbench procedure
SQL
0 vote451 views2 answers
Sqlalchemy default value for column
SQL
1 vote370 views1 answer
Select last row from SQL Table
SQL
0 vote331 views1 answer
Ms sql unique
SQL

Share