+ 1
What is the difference between 'LIMIT AND BETWEEN' when both are used to limit a set of columns of a table?
6 Réponses
+ 3
'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 ..
+ 2
limit is used for restricting records where between is used for restrictions imposed columns like sal b/w 4 and 5
+ 2
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.
+ 1
limit u can use without "where" but BETWEEN AND is used within WHERE
0
in the ms sql we dont have limit syntax.
0
limit will eexclude the first number because MySQL counts from zero but between will include the first number of the range.