How to get unique records.

Question

1.00/5 (1 vote)

See more:

Need unique record

e.g in the Name there is data as Nikhil Nikhil. I want output as Nikhil

Can you help me out please.

What I have tried:

-- Don't know how to get this one

Posted 14-May-18 12:02pm

Member 13138564

Updated 14-May-18 18:54pm

Add a Solution

Comments

RedDk 14-May-18 18:48pm

Find the blank space. Then find either everything which leads up to it or everything which follows it. Or ... SELECT * FROM table WHERE [Name] LIKE '%Nikhil%'

Since there's only one row of data, there is no duplicate record.

3 solutions

Solution 2

Here can be possible solution,

-> Split your name by space and get array
-> using id create tabular form link[^]

example:
From->
||id||name|||
|1|nikhil nikhil|
|2|mohibur rashid|

To->
||id||name||
|1|nikhil|
|1|nikhil|
|2|mohibur|
|2|rashid|

-> then run select query to group all the name and rejoin using group by id.

I do not know whether it will keep your mohibur rashid as it is, or change to
rashid mohibur

Posted 14-May-18 16:57pm

Mohibur Rashid

Solution 1

It seems to me that you want to rework your DB to store the first and last names in two fields. String mashing in SQL is always a last resort. DISTINCT will give you unique records, but that's not really what you're asking

Posted 14-May-18 13:18pm

Christian Graus

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

kirthiga S · Accepted Answer · 2018-05-14T18:55:00

Try this one

DECLARE @Table TABLE(Name varchar(100))
insert into @Table values('Nikhil Nikhil')
insert into @Table values('Nikhil Ram')
;with cte as (
select *,SUBSTRING(Name,0,CHARINDEX(' ',Name)) FirstName,SUBSTRING(Name,CHARINDEX(' ',Name)+1,LEN(Name)-CHARINDEX(' ',Name))LastName from @Table
)select Name Original_Name,case when FirstName=LastName then FirstName Else Name End New_Name from cte