/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

1 vote222 views2 answers
Sql select only first occurrence
SQL
5 votes279 views1 answer
Oracle ora-00054 find
SQL
0 vote220 views2 answers
Database owner can't create new tables postgres
SQL
0 vote236 views1 answer
Apex for oracle 11g
SQL
0 vote234 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote227 views1 answer
Soql user profile
SQL
0 vote228 views1 answer
Sql character index
SQL
0 vote214 views1 answer
Sql select non unique
SQL
0 vote240 views1 answer
Manage Database in MySQL
SQL
0 vote239 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL

Share