/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 vote169 views1 answer
Mysql get nth highest
SQL
0 vote154 views1 answer
Postgresql if else endif
SQL
2 votes171 views1 answer
Install postgresql centos 5
SQL
1 vote147 views1 answer
Group_concat order by
SQL
1 vote162 views1 answer
STOP message of how many rows affected sql
SQL
0 vote163 views1 answer
Plsql check for string in numeric
SQL
1 vote151 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote146 views3 answers
Above average salary in sql
SQL
6 votes149 views1 answer
Sqlite foreign key
SQL
0 vote154 views1 answer
Odd record sql query
SQL

Share