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.
The agricultural land below the main canal water level forms the ________.
Zerodha Asset Management Company (AMC) has received final approval from the market regulator SEBI to commence a mutual fund (MF) business.The new entr...
Where did the Minister of State for Communications, Devusinh Chauhan, inaugurate Hamfest India 2023, and what is its significance?
Which of the following is NOT a focus area of the AVGC-XR policy?
Which fintech platform is going to invest approximately Rs 100 crore in Gujarat International Finance Tec-City (GIFT City) for the development of a Glob...
Consider the following statements regarding instruments of Monetary Policy:
I. The Repo rate is the interest rate at which the Reserve Bank provi...
What is the significance of Rashtriya Chemicals and Fertilizers (RCF) being granted Navratna status by the government of India?
Sarathi, a first-of-its-kind digital onboarding journey to enable Electronic Data Capture (EDC) or Point of Sale (POS) for merchants to provide a seam...
Which bank has launched ‘Iris’ a mobile banking application that hosts services like opening a savings account, applying for a credit card or loan, ...
The Asian Development Bank (ADB) has approved a $200 million loan to strengthen flood and riverbank erosion risk management along the 650 kilometers (km...