Bhuvan A <bhuvansql@yahoo.com> writes:
> I need ONLY the 'n-1'th record.
See the 'LIMIT' and 'OFFSET' clauses in SELECT. Note the caveat that
you'd better ORDER the rows to be sure you know which is the n-1'th.
Having done an ORDER BY, you could simplify your life by reversing
the ordering and choosing the second row (OFFSET 1 LIMIT 1).
regards, tom lane