Thanks for your answers.I still have problem about it.
If I have a table which contains 100,000,000 records,but I only want to get 20 records once,such as from 100,500th to 100,520th.Use temp table,I must first select at least 100,520 records, it's terrible,right?
Can you point out what...