+ 1

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

17th Aug 2016, 8:59 AM
Umang Agarwal
Umang Agarwal - avatar
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 ..
17th Aug 2016, 2:51 PM
Maverick
Maverick - avatar
+ 2
limit is used for restricting records where between is used for restrictions imposed columns like sal b/w 4 and 5
18th Aug 2016, 9:47 AM
mahesh
+ 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.
23rd Aug 2016, 6:01 PM
Raton Kumar
Raton Kumar - avatar
+ 1
limit u can use without "where" but BETWEEN AND is used within WHERE
17th Aug 2016, 1:48 PM
manjunath
manjunath - avatar
0
in the ms sql we dont have limit syntax.
18th Aug 2016, 1:27 PM
AmirHosein
AmirHosein - avatar
0
limit will eexclude the first number because MySQL counts from zero but between will include the first number of the range.
18th Aug 2016, 11:05 PM
Samiul Sk
Samiul Sk - avatar