Query only unique records - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Query only unique records

Author

Topic

demods
Starting Member

6 Posts

Posted - 2005-10-26 : 05:48:23

I have a table named [CLIENTS]. I want to query some fields but I can't.

[CODE]CLIENTS

ID NAME CTG ITEM
----------------------------
1 ABCD 25 1
2 ABCD 25 2
3 ABCD 25 3
4 ABCD 26 1
5 ABCD 26 2
6 EFGH 30 1
7 EFGH 30 2[/CODE]

I want to get only the unique names like;

[CODE]
ID NAME CTG ITEM
----------------------------
1 ABCD 25 1
6 EFGH 20 1[/CODE]

Thanks....

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-10-26 : 06:23:14

Paste your code here

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-10-26 : 06:37:36

Use the logic suggested here
http://sqlteam.com/forums/topic.asp?TOPIC_ID=56940

Madhivanan

Failing to plan is Planning to fail

demods
Starting Member

6 Posts

Posted - 2005-10-26 : 08:13:57

I tried the code below but error occured

[CODE]SELECT T1.* FROM CLIENTS T1
INNER JOIN
(SELECT MIN(ID) AS ID, NAME, CTG, ITEM FROM CLIENTS
GROUP BY NAME) T2
ON T1.ID = T2.ID
AND T1.NAME = T2.NAME[/CODE]

I did something wrong but I don't know how to solve it. Thanks anyway...

mymatrix
Starting Member

24 Posts

Posted - 2005-10-26 : 08:35:20

May be this will help u -

select * from CLIENTS where ID in (
select min(ID) from CLIENTS group by NAME)

thnks
Gaurav

Even my blood group says be -ve to all the negatives.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources