/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 vote192 views1 answer
How to check database engine in mysql
SQL
0 vote147 views1 answer
Check connections to database postgres
SQL
1 vote206 views1 answer
Oracle check table lock
SQL
0 vote155 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
2 votes155 views1 answer
Mysql virtual column
SQL
0 vote165 views1 answer
Update top 100 order by sql server
SQL
1 vote154 views1 answer
Mysql how to reset primary key
SQL
3 votes158 views2 answers
Oracle apex charging debug
SQL
0 vote202 views1 answer
Inner join distinct
SQL
1 vote147 views1 answer
Sql myisam vs innodb
SQL

Share