[Sql Server 2005]
I have a view that returns certain records that were added over the past n minutes.
The sorting for these returned records isn't ideal. And of course, I can't sort in a view.
I wish the underlying table I'm querying from had an "implied sort", either by its identity ID field, or by a certain date/time field.
Is there any way I can get my returned records in this view to have an innate sort already applied to them?