About 1,796,142 results (1,393 milliseconds)
Having multiple values in one cell - Google Docs Editors Community
https://support.google.com/docs/thread/265682904/having-multiple-values-in-one-cell?hl=en Mar 24, 2024 ... I'm trying to use a google sheet to track my spread of revision. I'm currently tracking how many topics of 6 I cover each day, to then ensure an even spread ...
Using query to sum information from multiple columns according to ...
https://support.google.com/docs/thread/71369384/using-query-to-sum-information-from-multiple-columns-according-to-date?hl=en Sep 15, 2020 ... I have learned that I can use this equation to sum numbers from one column and group according to date: =QUERY(A:G,"Select A, sum(B) where A ...
update multiple columns
https://groups.google.com/g/mapinfo-l/c/xlH-8SDxXzI Feb 17, 2008 ... I would like to update more than one column with a single SQL statement but it appears that MapInfo only allows updating one column in a SQL ...
Query syntax | BigQuery | Google Cloud
https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax ... SQL! New name, same great SQL dialect. ... Scalar and array subqueries (see Subqueries) are normally not allowed to return multiple columns, but can return a ...
Query with multiple OR values in Sheets - Google Docs Editors ...
https://support.google.com/docs/thread/38275590/query-with-multiple-or-values-in-sheets?hl=en Apr 6, 2020 ... One of my fellow P.E.'s Matt:King brought it to my attention that it looks like your apostrophes might be a little curly.
Query: one field, one operator, multiple values
https://groups.google.com/g/mongodb-user/c/5Cf-iiqUDrQ Jul 12, 2010 ... I'm new to MongoDB and I wonder how to do the following query (pseudo- sql): SELECT * FROM xyz WHERE foo LIKE 'aaa' AND foo LIKE 'bbb'
Aggregate Functions
https://groups.google.com/g/django-developers/c/JFo3kSz41OM Aggregate functions perform calculations on columns. Typically they return a single value. They are in two groups: high_level and low_level.
I need to extract data from multiple columns based on the date ...
https://support.google.com/docs/thread/27901873/i-need-to-extract-data-from-multiple-columns-based-on-the-date?hl=en Feb 6, 2020 ... Your current structure of adding data to individual sheets/tabs and then looking to combine them into one larger sheet is the opposite of how ...
The future of the records mode
https://groups.google.com/g/openrefine/c/X9O8NBC1UKQ Each record can generate multiple values in a facet, so one has to think ... My first though reading this was about grouping the values in more than 1 column, ...
How to sort multiple data in spreadsheet? - Google Docs Editors ...
https://support.google.com/docs/thread/92341332/how-to-sort-multiple-data-in-spreadsheet?hl=en Jan 6, 2021 ... Select the following columns from this array, order them (sort) by column 6, then column 4, then column 5 – and this particular one (column 5) in descending ...
Using "ALTER TABLE ADD..." to add multiple columns
https://groups.google.com/g/h2-database/c/Kg4dB64ySfg So does Microsft SQL Server's T-SQL: ALTER TABLE customer ADD foo INTEGER ... + // ifNotExists only supported for single column add + if (ifNotExists ...
Schema design best practices | Bigtable Documentation | Google ...
https://cloud.google.com/bigtable/docs/schema-design If you plan to query your table using SQL, you can define structured row ... row in one column instead of multiple columns. With this approach, you use a ...
#23646 Enhancement: Updating multiple values in a single sql ...
https://groups.google.com/g/django-developers/c/Hcsh4r9_mHg Oct 20, 2014 ... Posting this Django Project ticket that I opened to track the enhancement request to update multiple rows with different values for the same ...
Compound unique constraint with a nullable column
https://groups.google.com/g/sqlalchemy/c/OqGoyCLSD6g A cross-platform compatible compound unique constraint over two columns where there can be only one record with NULL in one column and a given value in the ...
Subqueries | BigQuery | Google Cloud
https://cloud.google.com/bigquery/docs/reference/standard-sql/subqueries Scalar subqueries are often used in the SELECT list or WHERE clause. A scalar subquery must select a single column. Trying to select multiple columns will ...
GroupBy query performance on multivalue columns
https://groups.google.com/g/druid-development/c/YWEv_3DM8FQ 1) What is the cardinality of the multiple values for the categories dimension? You mention it might have up to 200 values per row, is it the same set of ...
Need help using the QUERY "WHERE" clause with multiple conditions
https://groups.google.com/g/google-visualization-api/c/eszt8oxb6ww Jul 4, 2023 ... Have you tried using the IN operator which is a standard method for SQL. If non numeric you need to enclose values with single quotes. HTH.
Please show me how to subtract columns - Google Docs Editors ...
https://support.google.com/docs/thread/20784105/please-show-me-how-to-subtract-columns?hl=en Nov 21, 2019 ... The formula works perfectly. Thank you for your patience. There may be one little problem however, the column fills with 0 from the current cell ...
Google Sheets: How to sort several data in the same cell - Google ...
https://support.google.com/docs/thread/34372191/google-sheets-how-to-sort-several-data-in-the-same-cell?hl=en Mar 19, 2020 ... the reason spreadsheet have cells is to keep data separate. One piece of data belongs in one cell. If you have many genres, create many columns ...
Using QUERY to sort multiple columns - Google Docs Editors ...
https://support.google.com/docs/thread/22693109/using-query-to-sort-multiple-columns?hl=en Dec 12, 2019 ... This question is locked and replying has been disabled. I have the same question (8).