Continue with your mobile number
To get the third-highest salary, the query SELECT salary FROM Employee ORDER BY salary DESC LIMIT 1 OFFSET 2; fetches the salary value after skipping the top two highest salaries. The outer query ensures that we only get the third-highest salary. Why Other Options are Wrong: a) Incorrect usage of LIMIT; it should be OFFSET 2 instead of LIMIT 2, 1. b) This would return multiple rows or result in an error. c) DISTINCT is unnecessary and could result in wrong data if multiple employees have the same salary. e) This query would return the first three salaries in ascending order, not the third-highest.
Under the Public Distribution System which of the following is not being allocated to the States/UTs for distribution form union government?
Who among the following has been honoured with Indian Film Personality of the Year at 53rd IFFI?
What is the current Public Provident Fund (PPF) interest rate for January-March 2025, as per the unchanged small savings rates?
Consider the following statements regarding the “Samagra Shiksha Scheme”;
I.Samagra Shiksha Abhiyan is a central Sponsored Scheme.
Which Steel company will manufacture India's first fire-resistant steel structures at its unit in Raigarh, Chhattisgarh?
______________ has been ranked eight for on-time performance among large international airports globally for 2021 by Cirium.
How much did the NRI deposits grow between April and August 2024?
What honor was recently bestowed upon the renowned fashion designer Rahul Mishra by the French government?