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

tiborPlease 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 ?