How to select a random record from a table?



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

Post New Answer

More Database Management Interview Questions

What is meant by a database?

1 Answers  


How does a database partition work?

1 Answers  


State three differences between Dbms and Rdbms?

1 Answers   BirlaSoft,


How data are stored in database?

1 Answers  


What do you mean by buffer manager?

1 Answers  


What is the purpose of a field in a database?

1 Answers  


Why do I need netlib?

1 Answers  


What are the characteristics of dbms?

1 Answers  


What are ACID properties?

11 Answers   Amazon, Cap Gemini,


What is user and end user?

1 Answers  


Define database lock?

1 Answers  


What is denormalization and why would someone consider doing so?

1 Answers  


Categories