/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 vote214 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
1 vote230 views1 answer
Oracle plan hash value
SQL
0 vote171 views1 answer
Procedures and functions in pl/sql
SQL
1 vote413 views1 answer
Foreign key in oracle sql developer
SQL
0 vote207 views1 answer
Select row with latest date mysql
SQL
3 votes252 views1 answer
RENAME table pl sql
SQL
-1 vote200 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote212 views1 answer
Postgresql log
SQL
0 vote208 views1 answer
Print orcale
SQL
0 vote193 views1 answer
Sql server get date of previous sunday
SQL

Share