Women in Technology

Hear us Roar



Article:
  SQL Data Types
Subject:   Why doesn't the following query return me the nth highest value?
Date:   2006-03-27 12:25:24
From:   jaipalreddy
Response to: Why doesn't the following query return me the nth highest value?

hi sunil,


just replace = with < . u will definetly get the solution.actually rownum is assigned after retrieving the row.there lies the problem.


anyway u try this. u will get it