Results 1 to 2 of 2

Thread: SQL

  1. #1
    Join Date
    Dec 1969

    Default SQL

    I would like to know how i can retrieve second max of a field in a table. For ex i have a salary table which gives the details of salary drawn by all employees in an organisation. I want to write a query which gets the second largest salary from the table. Can u pls help me out to get this. Thanks in advance.<BR>Pls respond to meenamahadevappa@usa.net as early as possible.Looking forward for u&#039r reply.

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL

    select max(Salary) from Employee_Salary<BR>where Salary &#060; (select max(Salary) from Employee_Salary)<BR><BR>Arash

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts