I have this situation..
The Min funcition in SQL returns lowest value in query but I what to return is the 2nd lowest instead.
Take this table for example col=Pay(3000,2300,1000,1900,1200)
Min(pay)=$1000 but I want to return Min2ndlowest(pay)=1200
Is there a way to solve this problem.
Thanks for help rendered..