what is the difference b/w limit and BETWEEN ?

Answer 1

BETWEEN actually looks at the value stored in the field, while LIMIT simply returns the specified rows regardless of their value.

Answer 2

limit = rownum in oracle. between is an operator