New answers tagged


The standard approach to get rows N through M is to do something like SELECT * FROM (SELECT a.*, rownum rnum FROM (SELECT emp_id, last_name FROM employees WHERE positionID in (1,3) ORDER BY <<something>>) a WHERE rownum <= 60) b WHERE rnum > 50 Note that you need ...


To quote C.J. Date's book "An Introduction to Database Systems" "The rows of such a table can be thought of as the records of the file..." So, for databases, it is Row.

Top 50 recent answers are included