What is the SQL equivalent of the .Skip()
method in LINQ?
For example: I would like to select rows 1000-1100 from a specific database table.
Is this possible with just SQL? Or do I need to select the entire table, then find the rows in memory? I'd ideally like to avoid this, if possible, since the table can be quite large.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…