Tag: duplicates

Find duplicate email and copy value from one row and insert it another row with same emails in MySQL

i have user table which has four columns(id , email ,phone , status ) . i trying to copy phone number from one row by email and insert it in another row with same duplicate email where status is 1. …

Query to update duplicates

duplicates sql sql-server sql-update tsql

I have the following query that returns duplicates that i am running on sql server. So I need to write a query that will update second instance of the email address based on the select query that retrieves dulicates to for example imports@rohnis.com to imports@rohnis.com.duplicate. If it is info@eps.ws then info@eps.ws.duplicate. So basically postfix the email address with the word

Select duplicated values from one coloum and get there value in one row

database duplicates mysql sql

i have table with 2 columns like below I want to select all values from table but view it like below: Answer If you’re not trying to create extra columns in your output, you can simply use GROUP_CONCAT with the separator of your choice. For example: Output: Demo on dbfiddle

SQL delete duplicate rows based on multiple fields

duplicates postgresql sql sql-delete

I have the following table in sql: id | trip_id | stop_id | departure_time —————————————- 1 | 1| 1| 06:25:00 2 | 1| 2| 06:35:00 3 …

Extracting unique values with SQL [closed]

bash duplicates hive python sql

I’m new to SQL and would greatly appreciate your help with extracting data from a hive table. The table contains two relevant columns: host and url. The url column has a lot of duplicates and …

Combine SQL Data into 1 row

duplicates sql

I’m attempting to build code to create an SSRS report. The folder type ID 19 indicates a Member ID. If the Folder type ID includes a *1300 it indicates a provider ID that is located in that field, prior to the *1300. The issue with how I am currently doing it is that it is creating 2 rows. One where

Tag: duplicates

Find duplicate email and copy value from one row and insert it another row with same emails in MySQL

Query to update duplicates

Select duplicated values from one coloum and get there value in one row

SQL delete duplicate rows based on multiple fields

Extracting unique values with SQL [closed]

Combine SQL Data into 1 row

Filtering out duplicates yet showing non-duplicate rows from another column in one row

How to remove rest of the ordered rows with the same ID after the first row which occurs more than once with that ID?

How to remove rest of the rows with the same ID starting from the first duplicate?

Duplication of results after selecting data from two tables with the same values