Top-N Queries in Oracle, MS SQL Server and MYSQL

২৩ শে মে, ২০১৪ রাত ১১:৪৭

Top-N queries provide a method for limiting the number of rows returned from ordered sets of data. They are extremely useful when you want to return the top or bottom "N" number of rows from a set or when you are paging through data.

The classic Top-N style query uses an ordered inline view to force the data into the correct order, then uses the ROWNUM check to limit the data returned।



View this link

১ টি +০/-০