How to find the 4th minimum number !!


Hi,

I have 2,4,3,5,7,6,10,12,8,1 numbers. I want to find

1. The fourth minimum number
2. The minimun numbers between 4th to 6th.

Advance ThanX for your time & patience.

Thanks,
Kishore

Comments

  • Hi Kishore,

    Try following queries:

    1. Select NumCol From NumTab O Where (Select Count(*) From NumTab I Where I.NumCol < O.NumCol) = 3

    2. Select Min(NumCol) From NumTab Where NumCol Between 4 And 6

    and do let me know if you still have any problems.

    All the best
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion