What happens when we exceed the value of LIMIT than cardinality (number of rows) in SQL or MySQL ? | Sololearn: Learn to code for FREE!
Neuer Kurs! Jeder Programmierer sollte generative KI lernen!
Kostenlose Lektion ausprobieren
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 Antwort
+ 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