Simple Question

Results 1 to 2 of 2

Thread: Simple Question

  1. #1
    Join Date
    Dec 1969

    Default Simple Question

    I was wondering how to get the largest number of a column? For example my Products table consists of ItemID, and the other product information, and I want a script to get the Largest Value of the itemID column and add one to it... any ideas how I would do this? Thanks for the help :)

  2. #2
    Join Date
    Dec 1969

    Default Max function

    If itemid is unique in the table do this<BR>select max(itemid) from table_name

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts