Select distinct rows from duplicate rows....

Dear Gurus,

I have table with following entries

Table name = Customer

Name Weight
------------ -----------
Sanjeev 85
Sanjeev 75
Rajeev 80
Rajeev 45
Sandy 35
Sandy 30
Harry 15
Harry 45

I need a output as follow

Name Weight
------------ -----------
Sanjeev 85
Rajeev 80
Sandy 30
Harry 45

OR

Name Weight
------------ -----------
Sanjeev 75
Rajeev 45
Sandy 35
Harry 15

i.e. only distinct Name should display with only one value of Weight.
I tried with 'group by' on Name column but it shows me all rows.

Could anyone help me for above.

Thanking in Advance.

Regards
Sanjeev
sanjeev.atvankar@xxxxxxxxx
.

Relevant Pages

  • Re: Select distinct rows from duplicate rows....
    ... I have table with following entries ... Table name = Customer ... Name Weight ... Sanjeev 85 ...
    (comp.databases.ms-sqlserver)
  • Re: Strip out text from cells
    ... "Rick Rothstein" wrote: ... list of what you want to have after you process those entries. ... concerned is the lbs in weight (ie one column shows the weight in stones - ... my apologies if I was not as clear first time ...
    (microsoft.public.excel)
  • Having acces compute a formula
    ... ratio of weight per foot using a different form) the I want to be able to ... am paying for it and the total price that i am selling it for. ... the customer) based on the ratio that is for that pipe style. ... and to save information is what i nead help with. ...
    (microsoft.public.access.gettingstarted)
  • Re: Strip out text from cells
    ... I require G to return the weight in pounds from F (the first figure or two ... figures dependent on whether it is a single fig or double ie 1 lbs or 2lbs) ... "Rick Rothstein" wrote: ... list of what you want to have after you process those entries. ...
    (microsoft.public.excel)
  • Re: Excel, Access, or Something Else?
    ... Sounds like one thing you need is an incrementing ticket number. ... > a full truck of metal and then enter the empty weight of the truck. ... > T589 to start with for the next customer and name it T590. ... > would not be stored on the template because the name was entered and saved ...
    (microsoft.public.excel)