Re: 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 402,698 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,453 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: Programming Forums

retrieval of unique data

•

•

Join Date: Jul 2005

Posts: 7

Reputation: wani_raj is an unknown quantity at this point

wani_raj is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

wani_raj is offline

Offline

Newbie Poster

Re: retrieval of unique data

#3

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

Reply With Quote

Forum Highlights

Related Features

DANIWEB FEATURE INDEX

Advertisement

Statistics

Members: 402,698

Users Online Now: 2,453

Active IRC Users: 22

Forum Threads: 130,701

Forum Posts: 668,790

Code Snippets: 889

Blogs: 146

Blog Entries: 2,145

Directory Links: 568