getting total count even if osset giving no records postgres code example
Example: Limits the result count to the number specified
# Limits the result count to the number specified
df.limit(1).collect()
# [Row(age=2, name=u'Alice')]
df.limit(0).collect()
# []