Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    19

    Unanswered: Max ID of the Key Field in a table

    Hello Everyone!

    I am trying to get the Max Sequence ID from the Key Primary Field called Info_ID.

    Does any one know what the Syntax for this might be?

    Please advise ASAP!

    Thx!

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    select max(Info_ID) from table_name
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2003
    Posts
    19

    Thumbs up

    Originally posted by Marcus_A
    select max(Info_ID) from table_name
    Thx! That worked just fine!

Posting Permissions

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