What is the use of limit in mysql?



What is the use of limit in mysql?..

Answer / Reshma Kumari

In MySQL, the LIMIT keyword is used to constrain the number of rows returned by a SELECT statement. The syntax is: SELECT * FROM table_name LIMIT start_number, number_of_rows. It specifies the offset (start_number) from where the results should begin and the maximum number of rows (number_of_rows) to return.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More PHP Interview Questions

What is compact function php?

1 Answers  


Tell me what are the functions to be used to get the image's properties (size, width and height)?

1 Answers  


Version of php, apache ,mysql

1 Answers  


what is variable scope, which variables are accessible from where and what are "undefined variable" errors?

1 Answers  


What are the php variables?

1 Answers  


how to work lamp server

0 Answers  


Write a php script to get the largest key in an array?

1 Answers  


How to set cookies?

1 Answers  


Where is php code written?

1 Answers  


How to create an array in php?

1 Answers  


How many php based companies in bangalore and chennai and over all india ? most of the persons saying for 2 years and 3 years they will be getting less than 15k per month how far is it true ? is it good scope for experience people can any one tell the exact experience pay for php developers one yr experience how much sal we expect ? two yr experience how much sal we expect ? three yr expereince how much sal we expect ? please kindly reply to the above questions as an experts you only please kindly judge and tell your practical experience in PHP ?

3 Answers  


Do you have to initialize variables in php?

1 Answers  


Categories