How to select a random record from a table?
Answer / Anurag Kumar
To select a random record from a table, you can use the SQL RAND() function. The exact method depends on the specific database management system you're using. For example, in MySQL, you might use:`SELECT * FROM your_table ORDER BY RAND();`
| Is This Answer Correct ? | 0 Yes | 0 No |
What is meant by a database?
How does a database partition work?
State three differences between Dbms and Rdbms?
How data are stored in database?
What do you mean by buffer manager?
What is the purpose of a field in a database?
Why do I need netlib?
What are the characteristics of dbms?
What are ACID properties?
11 Answers Amazon, Cap Gemini,
What is user and end user?
Define database lock?
What is denormalization and why would someone consider doing so?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)