/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 vote193 views2 answers
Clear window pl sql
SQL
3 votes185 views3 answers
How to add month in update sql
SQL
0 vote189 views1 answer
Events not working db
SQL
1 vote208 views3 answers
Get all tables postgres
SQL
0 vote203 views1 answer
Sql drop procedure if exists
SQL
0 vote189 views1 answer
Data structures in sql
SQL
1 vote196 views1 answer
T-sql disable system versioning
SQL
0 vote223 views1 answer
SQL-Arten
SQL
0 vote198 views1 answer
Laravel eloquent get generated sql
SQL
1 vote209 views1 answer
Postgresql substring last
SQL

Share