Question
Which SQL query will retrieve the second highest salary
from an Employee table?Solution
This query correctly retrieves the second-highest salary by first finding the maximum salary and then searching for the maximum salary that is less than the first maximum. The subquery (SELECT MAX(Salary) FROM Employee) retrieves the highest salary, and the main query finds the maximum salary that is smaller than that value, effectively returning the second-highest salary. This method ensures that the second-highest salary is retrieved by eliminating the highest salary and then finding the next largest value. Why Other Options Are Incorrect:
- B) This query would retrieve the third-highest salary, not the second-highest, due to the OFFSET 2 . It skips the first two salaries, resulting in the third.
- C) This query retrieves the highest salary, not the second-highest, by selecting the maximum salary without any condition.
- D) This query retrieves all salaries greater than the average salary, which does not necessarily provide the second-highest salary. It is based on a statistical average, not ranking.
- E) This query correctly retrieves the second-highest salary but uses LIMIT 2,1 , which might be seen as non-standard across different SQL systems. The approach is less elegant than option A for finding the second-highest salary.
Under which of the following methods is the latest cost of inventories charged to production but the old prices are charged to inventories in hand?
The following figures related to the rent and rates payable expense for a business in 2020-2021. Which is the correct figure for rent and rate expense ...
Calculate P/E Ratio from the following:
Equity share capital @ 10 each : 800000
9% preference share capital: 300000
Profit (afte...
Which among the following can be utilized for Buy Back of shares of an organisation?
Control Process consists of which of the following elements?
The adjustments required in cash flow from operations to find free cash flow to the firm are:
The stand-by Letter of Credit (LC) or Bank Guarantee (BG) issued by scheduled commercial banks for Gold (Metal) Loans should be denominated in:
An analyst who is interested in a company’s long-term solvency would most likely examine the:
If the arithmetic mean is 26.8 and the median is 27.9, then the mode is
Under the NPS Vatsalya scheme, partial withdrawal is allowed for purpose of education of subscriber, treatment of specified illnesses, disability more t...