Paging Through a Result
Assume that the formatting mode is set to Unformat and you have entered the statement:
SELECT * FROM Personnel.Employee
ORDER BY EmpNo;
The following screen is displayed:Figure 7: Personnel Screen #1
*** DATA AVAILABLE. READY FOR COMMAND. ***
This status message (displayed in the status area) indicates that the statement has returned more data than can be displayed in a single screen. To see the next page of the result, page forward.