how to avoid duplicate records in Select Query

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

HEllo Team,

I have table as follows:
Table Name : Qwner
ownername is one of the column.

OwnerName
Harshal
harshal
Tom
Sandip
Harshal

There are duplicate records in table . i want to avoid duplicate record .As i have try with distinct ,but no use..Please guide me..Do u have any other options.

Thanks
Harshal

Posted 26-Mar-14 6:43am

R Harshal

Add a Solution

Comments

[no name] 26-Mar-14 12:49pm

DISTINCT is the way to do this. In what way was it "no use"?

2 solutions

Add a Solution

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

OriginalGriff · Answer 1 · 2014-03-26T06:50:00

Solution 1

Try:

SQL

SELECT DISTINCT OwnerName FROM Qwner

Works fine for me when I test it with your data...

Posted 26-Mar-14 6:50am

OriginalGriff

Comments

Nirav Prabtani 26-Mar-14 12:52pm

my 5+

Richard C Bishop · Answer 2 · 2014-03-26T06:52:00

Solution 2

DISTINCT, as mentioned by InsertCleverUserName[^] is what you want, unless you have a unique identifier.

SELECT DISTINCT OwnerName FROM Owner

Posted 26-Mar-14 6:52am

Richard C Bishop

how to avoid duplicate records in Select Query

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to avoid duplicate records in Select Query

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us