Posted by Erland Sommarskog on 10/01/37 11:19

(medhanush@yahoo.com) writes:
> Can sb pl help to what t-sql query to use to achieve as follows,
> for some reason, there are duplicate rows, but i need to get
> top most rows of category A, B as follows.
>
> Num Category ProductName
> ---- -------- -----------
> 100 A Product1
> 100 B Product1
>
> 101 A Product2
> 101 B Product2
>
> 102 A Product3
> 102 B Product3

There is no such thing as a "top-most" row in a table. A table is an
orderd set.

It seems that with the sample data you have given that this would do:

SELECT DISTINCT Num, Category, ProductName
FROM tbl
WHERE Category IN ('A', 'B')

If product names are different, you can do:

SELECT Num, Category, MAX(ProductName)
FROM tbl
WHERE Category IN ('A', 'B')
GROUP BY Num, Category




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]