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 [at] gmail.com

select
[Name],
max([Weight]) as wgt
from
[Customer]
group by
[Name]

Cheers,
Jason Lepack

On Nov 28, 8:26 am, sanjeev.atvan... [at] gmail.com 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... [at] gmail.com

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... [at] gmail.com 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... [at] gmail.com

SELECT Name, MAX(Weight) AS Weight
FROM Customer
GROUP BY Name

or

SELECT Name, MIN(Weight) AS Weight
FROM Customer
GROUP BY Name

Denis The SQL Menace
http://sqlservercode.blogspot.com
http://sqlblog.com/blogs/denis_gobo/default.aspx



On Nov 28, 8:26 am, sanjeev.atvan... [at] gmail.com 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... [at] gmail.com

On Nov 28, 6:47 pm, Jason Lepack <jlep... [at] gmail.com> wrote:
> 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... [at] gmail.com 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... [at] gmail.com- Hide quoted text -
>
> - Show quoted text -

Note that SQL Server doesnt support first() or last() function