google-big-queryHow do I limit the results of a query in Google Big Query?
To limit the results of a query in Google Big Query, you can use the LIMIT
clause. This clause takes an integer as the argument, which is the maximum number of rows that will be returned by the query.
For example, the following query will return only the first 10 rows of the bigquery-public-data.usa_names.usa_1910_2013
table:
SELECT *
FROM `bigquery-public-data.usa_names.usa_1910_2013`
LIMIT 10
The output of this query will be:
+--------+-------+------+-------+
| name | state | sex | count |
+--------+-------+------+-------+
| Mary | CA | F | 619 |
| Helen | CA | F | 531 |
| Dorothy| CA | F | 476 |
| Margaret| CA | F | 467 |
| Ruth | CA | F | 415 |
| Anna | CA | F | 394 |
| Elizabeth| CA | F | 394 |
| Frances| CA | F | 340 |
| Marie | CA | F | 327 |
| Mildred| CA | F | 305 |
+--------+-------+------+-------+
The LIMIT
clause consists of the following parts:
LIMIT
: This is the keyword that tells BigQuery to limit the number of rows returned.10
: This is the argument that tells BigQuery to return a maximum of 10 rows.
Helpful links
More of Google Big Query
- How can I use Google Big Query to count the number of zeros in a given dataset?
- How can I use the CASE WHEN statement in Google Big Query?
- How can I use regular expressions in Google Big Query?
- How can I use Google BigQuery BI Engine to analyze large datasets?
- How do I use Google Big Query to zip files?
- How do I sign in to Google Big Query?
- ¿Cuáles son las ventajas y desventajas de usar Google BigQuery?
- How do I use wildcards in Google BigQuery?
- How can I use Google BigQuery on a Windows system?
- How can I use Google BigQuery to access Wikipedia data?
See more codes...