Search:

Type: Posts; User: pradyumna k j; Keyword(s):

Search: Search took 0.00 seconds.

  1. 03-10-2011

    Thread: How to display 3rd highest salary to 5th highest salary from emp table

    by pradyumna k j
    Answers
    9
    Views
    16,802

    SQL Re: How to display 3rd highest salary to 5th highest salary from emp table

    Hi,

    Here is the solution.

    SELECT salary
    FROM employee
    ORDER BY salary DESC LIMIT 2, 3


    I hope this will help you....
  2. 07-31-2010

    Thread: Thoughts of the day.

    by pradyumna k j
    Answers
    2,332
    Views
    439,926

    Re: How to find N th Highest Salary

    SELECT salary
    FROM employee
    ORDER BY salary DESC
    LIMIT n-1,1
  3. 07-31-2010

    Thread: Thoughts of the day.

    by pradyumna k j
    Answers
    2,332
    Views
    439,926

    Re: How to find Second Highest Salary

    SELECT salary
    FROM employee
    ORDER BY salary DESC
    LIMIT 1,1
Results 1 to 3 of 5
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact