DZone Database Zone
How to Write Efficient TOP N Queries in SQL
A very common type of SQL query is the TOP-N query, where we need the "TOP N" records ordered by some value, possibly per category. In this blog post, we're going to look into a variety of different aspects to this problem, as well as how to solve them with standard and non-standard SQL.
These are the different aspects we'll discuss:
No comments:
Post a Comment