adspace


What is limit in mysql?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to Change a users password from unix shell.

1221


What is current version of mysql?

1081


What is the current mysql version?

1103


Which statement is used in a select query for partial matching?

1247