/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

22 votes192 views3 answers
Remove all records from table mysql
SQL
0 vote175 views1 answer
Cast for print sql
SQL
0 vote182 views1 answer
How to put value in parameters in mysqldataadapter
SQL
1 vote204 views1 answer
Mysql check if string contains comma separated
SQL
4 votes185 views4 answers
Oracle tablespace tables list
SQL
3 votes140 views1 answer
Postgresql where current year
SQL
1 vote186 views4 answers
Mysqldump 1 table only
SQL
6 votes191 views1 answer
Oracle rank
SQL
0 vote187 views1 answer
Create table with primary key and foreign key in sql server
SQL
0 vote194 views1 answer
Sql dmv to capture updates
SQL

Share