/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 vote322 views1 answer
Comparing with today and yesterday record in sql query
SQL
3 votes289 views1 answer
RENAME table pl sql
SQL
0 vote319 views3 answers
Select top 10 rows in sql
SQL
1 vote314 views1 answer
Primary key with prefix sql
SQL
0 vote293 views1 answer
Sqlalchemy get schema from database
SQL
0 vote303 views1 answer
SQL Where-Klausel
SQL
0 vote282 views1 answer
Excute raw query
SQL
10 votes290 views5 answers
Between keyword in sql
SQL
11 votes283 views2 answers
Having in sql
SQL
2 votes288 views2 answers
Change varchar length mysql
SQL

Share