Which of the following query will return the third-highest salary from an Employee table in SQL?
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.
When goods are packed and transported with insurance, the supply of goods, packing materials, transport and insurance as per provisions of CGST Act, 20...
If a firm has 100 in inventories, a current ratio equal to 1.2, and a quick ratio equal to 1.1, what is the firm's Net Working Capital?
A setup in which group of individuals or entities decides to pool resources towards fulfilling a debt or financing a single borrower wherein the setup i...
Mr. X bought a bond at 1000 at a 10% coupon rate. But he intends to sell the bond after a year to Mr. Y. Mr. Y purchased the bond at 986. At the end of ...
NSDL and CSDL are the example of: -
Which of the following is not a quantitative tool of money supply used by the RBI?
________ fosters brotherhood among, employees and forms a key factor in raising employees' stake in the growth of an organisation. This is an extension ...
A company’s 1000 par preferred stock pays a Rs 50 annual dividend and has a required rate of return of 8%. Calculate the value of the preferred stock ...
_________ works a bridge that takes us from where we are to where we want to reach. It is the process of determining in advance what should be accomplis...
Warehouse expense is an example of: