Last Sales Price

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pratimapaudel
    New Member
    • Jul 2007
    • 24

    #1

    Last Sales Price

    Can anybody help me to find the last sales price. I have invoicedate , customer, sales price etc column available in my table. Table name is transactions.
    Max did not help . max brings highest sales price not last sales price.
    Thanks,
    Pratima
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    Can you use TOP 1 order by WhateverColumn DESC ?

    -- CK

    Comment

    Working...