Hi Mark

I have updated the original post with the new cID column values

I have a view and the following query which returns multiple records from the view (see below) for each iItemID

SELECT iItemID
        , cID
        , bRate
   FROM vwPriceListHistory
   ORDER by iItemID, cID DESC

What I want is one first record of each iItemID (ie. the latest price).  I have tried various combination of GROUP BY and FIRST 1 but I do not get the correct result, I just want:

iItemID, cID, bRate

35    201405135940      0         1825              34.740000

36    2015052513821     0         1825              46.140000

37    2017071522277     0         1880              2000.000000

Please advise

Kind regards

Bhavbhuti

iItemID, cID, bRate

35    201405135940      0         1825              34.740000
35    201404109498      0         388               43.231400
35    19000101                    0                 0.000000
36    2015052513821     0         1825              46.140000
36    2015052313816     0         1825              34.740000
36    2015051411442     0         1825              46.140000
36    2015051411441     0         1825              0.000000
36    201405135938      0         1825              46.140000
36    19000101                    0                 0.000000
37    2017071522277     0         1880              2000.000000
37    2017071522272     0         1880              200.000000
37    2017071122263     0         3263              434.000000
37    2016091718970     0         367               176.090000
37    2016052415723     0         367               176.000000
37    2016041715289     0         365               176.090000
37    2016041015232     0         2754              176.090000
37    2016020415103     0         365               251.500000
37    2015052113761     0         479               20.290000
37    2014100210133     0         365               176.090000
37    201308092879      0         481               216.580000
37    201304092645      0         365               163.050000
37    19000101                    0                 0.000000