/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 vote98 views1 answer
Oracle locked objects
SQL
0 vote102 views1 answer
Sql server delete records with specific date
SQL
0 vote105 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
20 votes104 views5 answers
Mysql reset auto increment to 1
SQL
0 vote99 views1 answer
Consecutive numbers sql
SQL
1 vote102 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote105 views1 answer
My sql data file extention
SQL
1 vote103 views1 answer
Varchar plsql
SQL
3 votes111 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote113 views1 answer
Mssql dockere
SQL

Share