Tag: rownum
-
Oracle top 1 record
To select the top 1 records from an oracle database, you filter with the where statement on rownum = 1: If you want to select top 10 records from the table you use the following statement:
To select the top 1 records from an oracle database, you filter with the where statement on rownum = 1: If you want to select top 10 records from the table you use the following statement: