/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

49 votes268 views6 answers
Alter table add column
SQL
1 vote250 views1 answer
Sql query row number group by
SQL
3 votes211 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
5 votes189 views2 answers
Sql server port number
SQL
7 votes194 views4 answers
How to reset the identity column in sql server
SQL
4 votes204 views1 answer
Sql data types
SQL
0 vote182 views1 answer
Gcloud check sql
SQL
0 vote181 views1 answer
Mysql use password error
SQL
0 vote190 views1 answer
Dump only data
SQL
1 vote184 views1 answer
How to start with sql
SQL

Share