First and last record in one query


(SANDPATH7) #1

Hi Guys,

Is it possible for me to get the first and the last record in one query? There is a crude way to set pagination to 1,1 and then total,total to get the first and last record but by doing this, i have to query 3 times.
First to get total records, second to get first and third one to get the last record.

Can i get first and last record in one shot.

Thanks,


(system) #2