rownum

Oracle select limit using rownum and rank()

**USING ROWNUM Oracle has a system attribute ROWNUM for each record returned. A query that only returns the first 20 records would look like the one in the example. ROWNUM starts counting with 1. // mysql select col from tbl limit 20; // Oracle select col from tbl where rownum<=20; // Microsoft SQL select top … Continue reading →