/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

1 vote194 views1 answer
Apex ORA-20999
SQL
0 vote196 views1 answer
Sql query for getting data with join and count
SQL
2 votes196 views1 answer
Oracle generated column
SQL
1 vote216 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote232 views2 answers
How to combine two sql queries in one result
SQL
0 vote203 views1 answer
Procedures sql insert mysql
SQL
4 votes199 views1 answer
Restart for pg_hba.conf file
SQL
4 votes190 views1 answer
Select nls_date_format
SQL
0 vote208 views1 answer
Excel export from sql using python
SQL
6 votes185 views1 answer
Oracle trigger after logon on database
SQL

Share