/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 vote149 views1 answer
How to install mysql without admin rights
SQL
1 vote143 views1 answer
Mysql select row max date
SQL
0 vote133 views1 answer
How to get employee having maximum experience in mysql
SQL
1 vote163 views2 answers
Logical operators in sql
SQL
3 votes153 views1 answer
Sql double index
SQL
0 vote166 views1 answer
Postgresql show owner of database
SQL
0 vote152 views1 answer
Sql comand for removing data from table
SQL
2 votes132 views2 answers
How to get capital letter first in sql
SQL
4 votes138 views1 answer
Oracle show errors compilation
SQL
0 vote166 views1 answer
Insufficient privileges while creating view in sql oracle
SQL

Share