Howdy, Stranger!

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

Categories

How to find the 4th minimum number !!

kishore_peddikishore_peddi Member Posts: 176

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

  • ShanooShanoo Member Posts: 32
    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.