Search results

I want nth record from sql server 7.0 group wise(per account no). But the recordset has more than 1 million records. I have tried this query: select top 1 FAH_AMT from ( select top 2 tmp1=h1.FAH_TDATE ,FAH_AMT,FAH_ACC_NO,FAH_TRCDE from HPLFAHISTORY h1 where FAH_ACC_NO = hfd.fadl_acc_no order...