adspace


What is the use of limit in mysql?

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


Please Help Members By Posting Answers For Below Questions

hello all, I need some sample placement papers in lion bridge.. can anyone help me?

2181


How can we extract string "pcds.co.in" from a string "https://info@pcds.co.in" using regular expression of php? More on reg can you explain

1082


Explain me is it possible to destroy a cookie?

1035


What is the current stable version of php? What advance thing in php7?

1100


How to create a web form?

1116


if you run the app program all vendor open items are cleared but is it possible to reverse the again again open items please tell me the answer

1997


How to calculate the difference between two dates using php?

1151


What sized websites have you worked on in the past?

1092


Tell me what kind of things have you done on the social side?

1071


What is difference between static and final in php?

1114


Name and explain five of the PHP error constants?

1043


List some features of php that are deprecated in php7?

1026


What is the difference between htmlentities() and htmlspecialchars()?

1100


sort term descripttion form, report and uery

2257


What is trait in php?

1072