to find 2nd highest salary in employee table
532522Oct 5 2006 — edited Nov 6 2006Hi,
I want to know how to calculate the 2nd highest salaried employee details.
rownum "=" sign cannot be used i suppose and
with and without using orderby clause.
both the methods needed.
cheers,