Skip to Content
0
Former Member
Jun 15, 2009 at 07:45 AM

How to take the Nth value?

21 Views

Hi Experts,

I am having a situation where I need to take the nth value after sorting in ascending order. Suppose, if

1. 10,

2. 20,

3. 30,

4. 40,

5. 50,

How to take the third value that is 30 and put it in the query designer?

Thanks in advance,

Regards,

Kannan