Start learning 50% faster. Sign in now
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:
Art. 165 of the Constitution deals with the appointment of ?
Jurisdiction in the case of Juveniles lies with?
Which of the following cases talks about an ex parte case coming under the purview of revisional jurisdiction as per s.115 of CPC?
In case of a decree for execution of a document, draft of document shall be prepared by__________________
The term debt has been defined under IBC as _________________
As per IPC provisions preparation stage of crime is punishable in following except _____
Which of the following best describes the scope of administrative law?
What is consent under the Indian Contract Act, 1872?
The auditor may be removed from his office before the expiry of his term only by a _______________ of the company, after obtaining the previous approval...
Res gestae is a latin term which means-