function like "Peek" to get the next record

[wanyunyang]

Hi guys,

I'm working on a report which requires me to get both the previous and the next record for every record in the output table. Now, I do asc/peek and desc/peek in two queries, but it takes a long time because it's a big output. Is there a way to use peek and something else like peek to get the next record in just one query?

Thanks in advance!

[h_prakash]

Please share a sample Data set and share the desired output.