retrieval of unique data

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 375,199 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,050 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser:

Thread Tools Display Modes

Views: 538 | Replies: 3

•

Join Date: Jul 2005

Posts: 7

Reputation: wani_raj is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

wani_raj

Offline

Newbie Poster

retrieval of unique data

Apr 10th, 2008

I want make a query to retrieve only those records from table which are unique on the basis of some coloumns

•

Join Date: Mar 2008

Posts: 115

Reputation: sonia sardana is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

sonia sardana sonia sardana is offline

Offline

Junior Poster

Re: retrieval of unique data

Apr 10th, 2008

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE TABLE student9(roll int)
INSERT INTO student9 VALUES(1)
INSERT INTO student9 VALUES(1)
INSERT INTO student9 VALUES(2)
INSERT INTO student9 VALUES(3)
SELECT DISTINCT * FROM student9
create table student9(roll int)
insert into student9 values(1)
insert into student9 values(1)
insert into student9 values(2)
insert into student9 values(3)
select distinct * from student9

Last edited by peter_budo : Apr 10th, 2008 at 4:25 pm. Reason: Keep It Organized - please use [code] tags

•

Join Date: Jul 2005

Posts: 7

Reputation: wani_raj is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

wani_raj

Offline

Newbie Poster

Re: retrieval of unique data

Apr 11th, 2008

•

Originally Posted by sonia sardana

Help with Code Tags

sql Syntax (Toggle Plain Text)
CREATE TABLE student9(roll int)
INSERT INTO student9 VALUES(1)
INSERT INTO student9 VALUES(1)
INSERT INTO student9 VALUES(2)
INSERT INTO student9 VALUES(3)
SELECT DISTINCT * FROM student9
create table student9(roll int) insert into student9 values(1) insert into student9 values(1) insert into student9 values(2) insert into student9 values(3) select distinct * from student9

It is retrieval of unique records from table but I want retrieval of those records which are unique on some coloumns eg if table have 5 coloumns I want to retrieve only those records which are unique on 3 coloumns suppose a student table stores details of all college students I want to retrieve those records which are unique on name and address

•

Join Date: Aug 2005

Location: Ohio

Posts: 204

Reputation: plazmo is an unknown quantity at this point

Rep Power: 3

Solved Threads: 16

plazmo

Offline

Posting Whiz in Training

Re: retrieval of unique data

Apr 15th, 2008

•

Originally Posted by wani_raj

It is retrieval of unique records from table but I want retrieval of those records which are unique on some coloumns eg if table have 5 coloumns I want to retrieve only those records which are unique on 3 coloumns suppose a student table stores details of all college students I want to retrieve those records which are unique on name and address

just replace the * with the column names...