Results 1 to 2 of 2

Thread: Counting rows

  1. #1
    Join Date
    Mar 2006
    Posts
    82

    Unanswered: Counting rows

    hi all

    quick question

    is there any way to set up a column that has the row count in it? i need this for a program i am developing and this would make it much easier to deal with. I know i can get a total count but when i run a count within a select statement i just get '1' for every row. thanks

    tibor

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Please restate your requirement in a clearer way. Do you need the row no for each row ? If that is the case, what happens if a row is deleted ???
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

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