/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

19 votes266 views6 answers
Sql server drop table if exists
SQL
0 vote252 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote266 views1 answer
Selecting duplicates
SQL
2 votes240 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote294 views1 answer
Database schema for mcqs type exam in sql
SQL
7 votes269 views3 answers
Sql set
SQL
0 vote258 views1 answer
Contact mysql column field
SQL
16 votes251 views3 answers
Delete row psql
SQL
0 vote244 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote254 views1 answer
Mysql select where field is a value
SQL

Share