/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

2 votes177 views2 answers
Sqlite_busy: database is locked
SQL
0 vote188 views1 answer
Regex any word except sql
SQL
0 vote189 views1 answer
Openquery join two tables
SQL
2 votes153 views1 answer
Oracle create directory
SQL
1 vote168 views2 answers
Postgresql remote connect
SQL
0 vote154 views5 answers
Sql table intermédiaire
SQL
5 votes157 views1 answer
Sql asynchronous stored procedure call
SQL
3 votes231 views2 answers
Oracle privileges users
SQL
41 votes253 views6 answers
Alter table add column in SQL Server
SQL
5 votes188 views1 answer
Oracle create table comment
SQL

Share