Re: Select distinct rows from duplicate rows....
- From: Jason Lepack <jlepack@xxxxxxxxx>
- Date: Wed, 28 Nov 2007 05:47:02 -0800 (PST)
Please note that because you don't care which weight you get, max()
can be replaced with min(), first(), last(), etc.
Cheers,
Jason Lepack
On Nov 28, 8:26 am, sanjeev.atvan...@xxxxxxxxx wrote:
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.atvan...@xxxxxxxxx
.
- Follow-Ups:
- Re: Select distinct rows from duplicate rows....
- From: Madhivanan
- Re: Select distinct rows from duplicate rows....
- References:
- Select distinct rows from duplicate rows....
- From: sanjeev . atvankar
- Select distinct rows from duplicate rows....
- Prev by Date: Re: Select distinct rows from duplicate rows....
- Next by Date: Re: Select distinct rows from duplicate rows....
- Previous by thread: Re: Select distinct rows from duplicate rows....
- Next by thread: Re: Select distinct rows from duplicate rows....
- Index(es):
Relevant Pages
|
