About 1,779,093 results (2,400 milliseconds)

Query syntax in GoogleSQL | Cloud Spanner | Google Cloud

https://cloud.google.com/spanner/docs/reference/standard-sql/query-syntax
A SELECT DISTINCT statement discards duplicate rows and returns only the remaining rows. SELECT DISTINCT cannot return columns of the following types: STRUCT ...

Append query without duplicate rows

https://groups.google.com/g/microsoft.public.access.queries/c/RX4mHD5ECno
included. --Close the index window and close and save the table. You can also restrict this in a query. Post the SQL of your current query and

bcp generating duplicate rows?

https://groups.google.com/g/sybase.public.sqlanywhere.general/c/3Fk6V0IcAQI
index, I would find it most disturbing if there are duplicate rows in there ... to your ASE database and then 'select into' your ASA 'real' tables from the ...

Find and fix inconsistent B-tree indexes | Cloud SQL for PostgreSQL ...

https://cloud.google.com/sql/docs/postgres/find-fix-inconsistent-indexes
In this output, the table header NOTICE shows the index, column, and table for the values displayed below it. If your output contains rows displaying DUPLICATE ...

Data manipulation language (DML) statements in GoogleSQL ...

https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax
Use the DELETE statement when you want to delete rows from a table. ... NULL = NULL evaluates to NULL instead of TRUE , and creates duplicate rows in the results.

DB2 and SQL Questions - Mary C Walter Consulting

https://sites.google.com/a/marycwalterconsulting.com/mary-c-walter-consulting/mainframe-expert-programmer/interview-questions/db2-questions
Jun 15, 2010 ... 1) How would you find out the total number of rows in a DB2 table? Use SELECT COUNT(*) ... in db2 query. 2) How do you eliminate duplicate ...

Cause of duplicate row and foreign key constraint errors in Rep ...

https://groups.google.com/g/sybase.public.rep-server/c/bUaB1Y7Ogwc
Feb 24, 2009 ... For duplicate key errors you want to find out why the SQL text is generating a duplicate key error in the replicate database. With the ...

combine duplicate rows in mapinfo table

https://groups.google.com/g/mapinfo-l/c/jQWWrF46WuM
In the Table menu you'll find the function called Combine objects using column.... ... If anyone knows of a way in sql or maybe an mbx I would appreciate it.

Enform user-defined variables

https://groups.google.com/d/topic/comp.sys.tandem/K7gVjFzKVS0
Mar 1, 2015 ... ... find any records that are identical and drop all but one ... As far as I know, standard SQL specifies that DISTINCT removes duplicate rows from ...

How to split comma separated text into rows and duplicate values to ...

https://support.google.com/docs/thread/210207628/how-to-split-comma-separated-text-into-rows-and-duplicate-values-to-the-new-rows?hl=en
Apr 9, 2023 ... What i can't manage to do is that it separates the column with product names into single rows and adds all the needed data next to it. I know it ...

Django equivalent to a SQL CASE statement?

https://groups.google.com/g/django-users/c/lCVS4IWpi5s
Also, am I alone in being a bit wary of the django ORM after reading... 'By default, a QuerySet will not eliminate duplicate rows. In practice, this is ...

sql - Split date range into new records in Snowflake View - Stack ...

http://feedproxy.google.com/~r/stackoverflow/ynOn/~3/vMIYgs1DWBc/split-date-range-into-new-records-in-sql-view
Oct 6, 2020 ... You can use a recursive CTE: with cte as ( select PersonID, CompanyID, Start_DT as new_dt, End_DT from t union all select PersonID, ...

Query syntax | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax
A SELECT DISTINCT statement discards duplicate rows and returns only the remaining rows. SELECT DISTINCT cannot return columns of the following types: STRUCT ...

How to keep only one of duplicates records

https://groups.google.com/g/openrefine/c/ai8EI1QLEL0
Take a look at Facets -> Customized facets -> Duplicate facets (then you might click on "false" to select only the rows that are not duplicated). In order to ...

mysql - How to delete old duplicate rows based on 2 columns but ...

http://feedproxy.google.com/~r/stackoverflow/ynOn/~3/72cC9NkTJGc/how-to-delete-old-duplicate-rows-based-on-2-columns-but-keep-the-latest-row
Jun 15, 2019 ... The traditional way in MySQL uses a JOIN : delete tt from test_table tt join (select tt.hotel_id, tt.user_id, max(tt.id) as max_id from ...

Multi row insert with On Duplicate Update (Microsoft Sql Server)

https://groups.google.com/g/jooq-user/c/YivILNbGMXo
Jul 5, 2016 ... we are currently evaluating Jooq in a prototype context in order. to find out if we can use it later in production. So far it seems. pretty ...

Deletion of duplicate rows in a table

https://groups.google.com/g/comp.databases.informix/c/peJFHeP2wpo
Is it possible in Ansi-Sql ? I tried using the following query but it is giving a syntax error : delete from table where ( select column 1, column 2 from ...

How To Find Duplicate Entries Using SQL

https://groups.google.com/d/topic/comp.databases.informix/lFD6pkgDkDA
Mar 6, 2002 ... database. I first thought the following code was okay since I was looking for not distinct serial numbers: | SELECT NOT DISTINCT serial_no | ...

How to find duplicate rows with Web2py DAL

https://groups.google.com/g/web2py/c/8APvr5j_CFk
... duplicate records (rows) in one table of my Postgres database. Quick google-ing reveals it is easy to do it with pure SQL, e.g. one way specific for ...

need help finding duplicate records

https://groups.google.com/g/openrefine/c/B2WAZW-1MPM
Jan 26, 2016 ... ... and then excluded the false rows -- and the remaining set of rows are not duplicates, I know this from checking the data via hand built sql.