What is the query to display top 20 rows?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MySQL Interview Questions

What is int unsigned?

0 Answers  


What is schema in mysql?

0 Answers  


What is processlist in mysql?

0 Answers  


What are programming functions?

0 Answers  


How can you validate emails using a single query?

0 Answers  






Is mysql case-sensitive?

0 Answers  


The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 Answers  


What is the difference between MyISAM Static and MyISAM Dynamic?

0 Answers  


Do you need a license for mysql?

0 Answers  


How to create a new table in mysql?

0 Answers  


Why does mysql have so many connections?

0 Answers  


How to copy data from one server to another using php?

0 Answers  


Categories