What is the difference between 'LIMIT AND BETWEEN' when both are used to limit a set of columns of a table?

Answer 1

'Limit' is used to set a boundary for retrieving record.. Whereas 'Between' is used within 'WHERE' clause to fulfill a specific criteria and will show only the columns which fulfill those criteria ..

Answer 2

limit is used for restricting records where between is used for restrictions imposed columns like sal b/w 4 and 5

Answer 3

when we query on database table it will give us result-set as our described criteria. criteria may be between -- and --. now we will use limit to show how many row we want.

Answer 4

limit u can use without "where" but BETWEEN AND is used within WHERE

Answer 5

in the ms sql we dont have limit syntax.

Answer 6

limit will eexclude the first number because MySQL counts from zero but between will include the first number of the range.