Posted by SQL Menace on 11/28/07 13:50

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...@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...@gmail.com

• Next in forum: Re: Clustering, Security, Performance, Load Balance
• Prev in forum: Re: Select distinct rows from duplicate rows....
• Thread view: Re: Select distinct rows from duplicate rows....

[Reply to this message]