There are different records in SQL Table Transformer, but among them there are many duplicate records.So I want to delete duplicate so that only unique records remains
For eg
Input ( 4 Records)
Name Age City
John 26 London
Snow 27 New York
John 26 London
Snow 27 New York
Output (2 Records)
Name Age City
John 26 London
Snow 27 New York
Hi @Dhiraj Kr_ Gupta ,
The following query should be working fine for you:
SELECT 'Name', 'Age', 'City'
FROM
(SELECT
DISTINCT('Full String'),
*
FROM
(SELECT 'Name' + 'Age' + 'City' AS 'Full String',
*
FROM T*))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.