Unanswered: How to know the order of entries in a table
For example some data has entered into a table in a random manner i.e the pk filed value is not in a serial fashion.Is there any table or index that holds the entries of rows into a particular table as entered .
'some_table' has data like this
I want some DB table or Index that holds data like this about above 'some_table'
row_id .... .... ....
here 1 refers to entry of the first column in 'some_table' i.e 3,entry3
and so on...
There is no order. If you need to know the order that data was inserted then you need to set something up yourself - use an identity column or a timestamp with a GETDATE() default value. Note that the second option will result in "ties" if you insert sets of data.