Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    5

    Unanswered: Query to retrieve the maximum sequence number

    Hi,
    I have the following rows in one table:

    agnum sitenum seqnum

  2. #2
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Arrow Sequence Numbers

    Hi
    R u talking about sequence numbers.
    R those system defined sequences, or u r maintaining the sequence numbers in a table.
    It is normally a good idea to maintain the sequences at system level, and you could add properties to the sequence as autoincrement or autodecrement .. etc.
    Thanx and Regards
    Aruneesh

  3. #3
    Join Date
    Jul 2003
    Posts
    5

    Re: Sequence Numbers

    Arun,
    I am sorry i did not post my question in full earlier, just a few mins ago I submitted my question in full. Can you take a look at it and send me a reply??


    THanks

    Jayanthi

    Originally posted by aruneeshsalhotr
    Hi
    R u talking about sequence numbers.
    R those system defined sequences, or u r maintaining the sequence numbers in a table.
    It is normally a good idea to maintain the sequences at system level, and you could add properties to the sequence as autoincrement or autodecrement .. etc.
    Thanx and Regards
    Aruneesh

Posting Permissions

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