Question

give me a query to find out the second largest compensation in an organization ?

Answer 1

HEY DEAR!!

YOUR ANSWER HERE...

__________

here are many ways to find second highest salary based upon which database you are using as different database provides different feature which can be used to find second maximum or Nth maximum salary of employee. Well this question can also be generalized with other scenario like finding second maximum age etc.

__________

HOPE HELPED:)

Answer 2

answer to your question is given in the attachment

HOPE THIS HELPS :)