You may use below command to limit the query result. Taking on example for SAP table E070, column E070.
The query will list out the latest 8 rows inserted to the E070 table, specifically on TRKORR column.
select TRKORR from SAPSR3.E070 where rownum <= 8; TRKORR ------------------------------------------------------------ DEVK900010 DEVK900011 DEVK900012 DEVK900013 DEVK900014 DEVK900015 DEVK900016 DEVK900017
If you want to list the result of the first 8 rows or last 8 rows, you may need to use the ORDER by query. The command will sort the result by ascending or descending order.
#DESCENDING ORDER SQL> select TRKORR from (select TRKORR from SAPSR3.E070 order by TRKORR DESC) where rownum <=8; TRKORR ------------------------------------------------------------ DEVK900020 DEVK900021 DEVK900022 DEVK900023 DEVK900024 DEVK900025 DEVK900026 DEVK900027 8 rows selected.
#ASCENDING ORDER SQL> select TRKORR from (select TRKORR from SAPSR3.E070 order by TRKORR ASC) where rownum <=8; TRKORR ------------------------------------------------------------ DEVK900001 DEVK900002 DEVK900003 DEVK900004 DEVK900005 DEVK900006 DEVK900007 DEVK900008 8 rows selected.
