postgresql count all record and a subset in one query 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()
# []