---
title: "Why do I get only 300 rows when I fetch data using the SELECT query in ZCQL?"
url: https://docs.catalyst.zoho.com/en/faq/cloud-scale/datastore-zcql/
description: "SELECT , UPDATE , INSERT , DELETE allow you to fetch a maximum of 300 rows in one query in adherence with the industry standards. If you require more records to …"
last_updated: 2026-11-13T05:00:22Z
service: CloudScale
type: faq
---

SELECT *, UPDATE *, INSERT *, DELETE * allow you to fetch a maximum of 300 rows in one query in adherence with the industry standards. If you require more records to be fetched, you can use the LIMIT clause to iterate the query and specify the offset and value accordingly.