/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 vote231 views1 answer
Load utilities in sql server
SQL
1 vote312 views1 answer
Mysql get max value and id
SQL
-1 vote224 views2 answers
How to display top 50 rows?
SQL
3 votes236 views1 answer
Sql is not like
SQL
4 votes205 views1 answer
Sql list users and roles
SQL
0 vote236 views1 answer
Android sqlite add column if not exists
SQL
0 vote233 views1 answer
Sql query interview questions githu
SQL
0 vote219 views1 answer
Dump only schema
SQL
0 vote248 views1 answer
T-SQL Create Trigger
SQL
0 vote235 views1 answer
What alter does in db
SQL

Share