/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 vote139 views1 answer
Sql add calculated column
SQL
6 votes141 views2 answers
Psql load dump
SQL
3 votes97 views1 answer
System.debug apex
SQL
0 vote129 views2 answers
How to set global time_zone in mysql
SQL
0 vote170 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote131 views1 answer
How many rows affected in sqllite
SQL
0 vote125 views1 answer
Create date sql
SQL
1 vote134 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote138 views2 answers
Sql select inside select
SQL
1 vote220 views1 answer
Oracle create program if not exists
SQL

Share