Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.


Archive: 5th Maximum

Bottom of Page

1 to 2 of 2

  1.  
    • CommentAuthorashmi
    • CommentTimeOct 30th 2006
     
    I want to retrieve 5th max no from sql table , field name is salary.

    Anyone can help?
    • CommentAuthorjustnajm
    • CommentTimeNov 21st 2006
     
    Hi,


    SELECT max(salary)
    FROM emptbl
    WHERE salary 
    NOT IN(
                 SELECT TOP 4 salary 
                 FROM emp 
                 ORDER BY salary desc
                 )


    Hope I answer the question.

1 to 2 of 2

  1.