Sometimes you need to return a limited number of rows such as selecting the first 10 rows of some table, web will show how to do this using MySQL, Sql Server and Oracle

Selecting random records in Oracle

Selecting random records in Oracle, For some reasons you may want to select some random records from a table to perform some processing on them,  I will show how to Select random records in Oracle