Start learning 50% faster. Sign in now
This query uses a subquery to find the maximum salary and excludes it using NOT IN. The outer query then finds the maximum salary among the remaining values, effectively identifying the second highest salary. • Why this works: The subquery isolates the highest salary. The outer query ensures the second highest value is identified without requiring an OFFSET. This method works across most SQL systems and avoids platform-specific syntax like LIMIT or TOP. ________________________________________ Why Other Options Are Incorrect: 1. LIMIT 2: Returns two highest salaries but doesn’t isolate the second highest. 2. OFFSET 1: Many SQL platforms do not support LIMIT ... OFFSET or require modifications for accurate execution. 3. DISTINCT Salary: Redundant use of DISTINCT, which is unnecessary when ORDER BY already ensures unique ordering. 4. TOP 2: TOP is SQL Server-specific and requires additional filtering for the second value.
Which among the following are the functions of Money?
a) Unit of value
b) Standard for deferred payment
c) Store of value
d) Medium of exchange
How many members of a trade union must provide consent for a name change to occur?
A company’s financial details as of 31.03.2023 are as follows:
With which of the following was Narayana Guru associated?
Which is the major component of biogas ?
The difference of the greatest and smallest of the fractions
Which of the following authorities is responsible for implementing the provisions of the Social Security Code 2020?
Which accounting principle requires that revenue is recognized when a sale is made or a service is provided?
Which of the following is an example of connectivity ?