What happens when we exceed the value of LIMIT than cardinality (number of rows) in SQL or MySQL ? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

What happens when we exceed the value of LIMIT than cardinality (number of rows) in SQL or MySQL ?

Does it produce error or what ??

28th Oct 2020, 5:02 PM
Lakshya Mittal
Lakshya Mittal - avatar
1 Answer
+ 1
You should have easily tried it yourself. By the way if the limit value exceeds the row count then it will not throw any error because the limit value simply says return so and so records if present or return how much ever is there.
29th Oct 2020, 3:52 AM
Avinesh
Avinesh - avatar