Does limit always tend to zero only?

No, limit can tend to any finite number including 0. It is also possible that the limit does not tend to any finite value or approaches infinity.

Example:

The limit of x^2+5 tend to 6 as x approaches -1.