MS SQL

MS SQL RSS

retrieval of unique data

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Jul 2005

Posts: 7

Reputation: wani_raj is an unknown quantity at this point

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: 324

Reputation: sonia sardana has a little shameless behaviour in the past

Solved Threads: 7

sonia sardana sonia sardana is offline

Offline

Posting Whiz

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 5: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

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

Posts: 206

Reputation: plazmo is an unknown quantity at this point

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...