Top-N queries in Oracle SQL by Rocky Jagtiani Oracle Certified Associate I train on Oracle Certification from last 7 years I decided to write about Top-N queries today because even though there are lots of articles and documentation about the correct way to do it in Oracle out there, I have seen this question asked on different forums, and to my surprise, many times people suggesting incorrect ways to do it without anyone clarifying their mistake. Now, every time I see the question again, I will have a trustworthy link to share with my students, data analyst and data-science-learners !! Contents [ 25 mins to read & Execute ] What are Top-N queries? Using the rownum pseudocolumn Using analytic functions Using the row limiting clause For understanding Top-N Queries , make sure of : 1> Installing Oracle-11g ( steps of installation and Oracle-11g download copy is here , please see Oracle SQL - Pl/SQL > downloads section ). By the way any version ...