Sql 2000 Problem

Question

Sql 2000 Problem

Sarvesh Kumar Gupta

SSC Eights!

Points: 821
More actions
October 10, 2007 at 6:49 am

#62169

i have a table.
fields =
1) Id
2) name
3) EmailId
4) Age
5) Salary
now i want distinct recordsbased on name and EmailId then what should do me

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 1

select DISTINCT name, emailID from table

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Sarvesh Kumar Gupta SSC Eights! Points: 821 More actions · Answer 2

this is right but i want to find out all fields whereas it gives only two field.

Prasad Bhogadi SSCrazy Eights Points: 9235 More actions · Answer 3

You may want to create a temp table and dump the data into that table and delete the duplicate rows using a cursor and fetch the data and display it to the end user.

Because if you want to include all the columns you need to include them in group by or distinct and that would not yeild you what you are desiring to. Cursors are not recommended because of performance issues.

Prasad Bhogadi
www.inforaise.com

Kenneth Wilhelmsson SSC-Dedicated Points: 30043 More actions · Answer 4

Give some example of what your data looks like, and on that data, how you wish to apply the 'distinct'..

That is, indata, and expected output from that data.

/Kenneth

mrpolecat SSCertifiable Points: 6964 More actions · Answer 5

you need to decide what aggregate you want for the other fields. If you want the highest age and salary for each name and email combination you could try this

select max(id),name,email,max(salary),max(age) from table group by name,email