This week's book giveaway is in the Java 9 forum. We're giving away four copies of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications and have Sander Mak & Paul Bakker on-line! See this thread for details.
Is there a way to return a row #? I'm trying to rank something based on a sorted column, but i'm not sure how to get the row number w/out looping through the entire resultset with a counter and matching my expression.
I'm using hibernate, but i dont even know if there is a simple method in SQL.
posted 9 years ago
I believe that this is database-specific, like rownum in Oracle.