Do SQL server have some functions as like "Select bottom"?

[caiguosen]

I have thousands of tables, and the fields are always ordered by date, and i want to select bottom 60 from all the tables. I know I can realize this function by following statement: select top 60 from table order by date desc but I don't want to use "order by", all my data is sorted and it will waste my time. so can I get the bottom 60 record from the db? Is there any function like "select bottom 60"?

[i j russell]

Yes, SELECT TOP 60 FROM Table ORDER BY date DESC. If it is good enough for every database professional on every database platform, then I would suggest that it isn't as bad as seem to think! If I understand what you mean by 'sorted' then I suggest that you find an article/book about how databases store data; I think that you will be very surprised.

[Mycroft Holmes]

caiguosen wrote:

but I don't want to use "order by", all my data is sorted and it will waste my time.

Then get a different job and don't waste our time.

Never underestimate the power of human stupidity RAH

[dan sh]

If you are already ordering the fields and know you need records from end, why not store them the opposite way as current. I mean order records from current to older dates. In that case all you will need is to get top xx records from the table. This should have been thought while designing database IMHO.

"No matter how many fish in the sea; it will be so empty without me." - From song "Without me" by Eminem