What is limit in mysql?



What is limit in mysql?..

Answer / Nitesh Kumar Chaudhury

Limit in MySQL is a clause used to restrict the number of rows returned by a SELECT statement. The LIMIT clause can be used to specify the maximum number of rows to return, as well as the offset from which to start returning rows.nFor example: SELECT * FROM table_name LIMIT 10 OFFSET 20; This query would return the next 10 rows after row 20 from the 'table_name' table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How does mysql store dates?

1 Answers  


How to enter microseconds in sql statements?

1 Answers  


What is the usage of regular expressions in mysql?

1 Answers  


What is a delimiter in mysql?

1 Answers  


What is mysql connection limit?

1 Answers  


maximum database size of mysql database

2 Answers  


Can you tell what are various ways to create an index?

1 Answers  


What is the use of indexing table?

2 Answers  


How do I find mysql location?

1 Answers  


What are the steps involved in query processing?

1 Answers  


What is mysql installer?

1 Answers  


Is mysql query case sensitive?

1 Answers  


Categories