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:
Which of the following Physicist co written relativity theory manuscripts sold for how much dollars?
What is the currency of South Africa?
According to Forbes, who is India's Richest person of India in Dec 2022?
Which of the following became the first Indian company to buy UAE’s T20 League franchise?
Which company has entered into a joint venture agreement with Kowa Holdings for the sales and marketing of green ammonia & green hydrogen produced and s...
Which scheme was launched by the Union Agriculture Minister to support tech-driven ventures in rural areas?
SoftBank has sold 2 percent of its shares in One97 Communications, the parent firm of Paytm.After the latest sale, SoftBank’s stake in the company is ...
Who has been appointed as the State Election Commissioner (SEC) of West Bengal?
For what reason was PNB penalized by RBI of Rs 1.32 crore penalty?
Consider the following statements aboutGreen rising initiative:
1. Recently, UNESCO in collaboration with India's Ministry of Environment...