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
  • [firebird-support] ... venussof...@gmail.com [firebird-support]
    • Re: [firebird-... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
      • Re: [fireb... venussof...@gmail.com [firebird-support]
        • Re: [f... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
          • [f... venussof...@gmail.com [firebird-support]
            • ... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
              • ... venussof...@gmail.com [firebird-support]
    • Re: [firebird-... setysvar setys...@gmail.com [firebird-support]

Reply via email to