title: get last value from select
body: <p>hi I'm trying to get the last value from a select, it that possible? I've tried the following: </p>
  
  <pre><code>update order set order_total =
  (select last item_cost  * order_quantity
  FROM order_stock, order
  WHERE order_stock.menu_item = 
  order.menu_item);
  </code></pre>
  
  <p>if i select  item_cost  * order_quantity
      FROM order_stock, order
      WHERE order_stock.menu_item = 
      order.menu_item it will return 2 values , i only want get retrieve the last entry</p>