Help query

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Prabu Krishna
    #1

    Help query

    I having employees records which contanis 100 records,contain s
    emplyeeid,name, salary as fields


    Question 1.
    I need to find the 10th maximum salary of the employees

    question 2.

    I need to find the 60th maximum salary of the employees


    Question 3.
    I need to find the 10th minimum salary of the employees

    question 2.

    I need to find the 60th minimum salary of the employees


    All this should be done by a query.How is it is possible?
    Tags: None
    • Jim Kennedy
      #2
      Re: Help query

      look at analytics. also asktom.oracle.c om
      Jim
      "Prabu Krishna" <prabukrishna@h otmail.comwrote in message
      news:4de9020f.0 309060813.17f95 df3@posting.goo gle.com...
      I having employees records which contanis 100 records,contain s
      emplyeeid,name, salary as fields
      >
      >
      Question 1.
      I need to find the 10th maximum salary of the employees
      >
      question 2.
      >
      I need to find the 60th maximum salary of the employees
      >
      >
      Question 3.
      I need to find the 10th minimum salary of the employees
      >
      question 2.
      >
      I need to find the 60th minimum salary of the employees
      >
      >
      All this should be done by a query.How is it is possible?

        Comment

        • Anna C. Dent
          #3
          Re: Help query

          Prabu Krishna wrote:
          I having employees records which contanis 100 records,contain s
          emplyeeid,name, salary as fields
          >
          >
          Question 1.
          I need to find the 10th maximum salary of the employees
          >
          question 2.
          >
          I need to find the 60th maximum salary of the employees
          >
          >
          Question 3.
          I need to find the 10th minimum salary of the employees
          >
          question 2.
          >
          I need to find the 60th minimum salary of the employees
          >
          >
          All this should be done by a query.How is it is possible?
          For which school, class & instructor gave you this assignment?

            Comment

            • lokys
              #4
              Re: Help query

              use rownum = 10 before group by

              prabukrishna@ho tmail.com (Prabu Krishna) wrote in message news:<4de9020f. 0309060813.17f9 5df3@posting.go ogle.com>...
              I having employees records which contanis 100 records,contain s
              emplyeeid,name, salary as fields
              >
              >
              Question 1.
              I need to find the 10th maximum salary of the employees
              >
              question 2.
              >
              I need to find the 60th maximum salary of the employees
              >
              >
              Question 3.
              I need to find the 10th minimum salary of the employees
              >
              question 2.
              >
              I need to find the 60th minimum salary of the employees
              >
              >
              All this should be done by a query.How is it is possible?

                Comment

                Previous template Next
                Working...