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.
What are the characteristics or features of the extent of the absolute liability rule as mentioned?
Any arrangement requiring a purchaser of goods, as a condition of such purchase, to purchase some other goods is:
Who shall constitute the Committee of Creditors as the IBC?
Under which section of Indian Evidence Act, a public servant shall not be compelled to disclose communications made to him in official confidence?
Identify the punishment which is not prescribed under the category of punishments in the Indian Penal Code:
Extreme old age when a man behaves like a child is called :
Writ of Certiorari can be filed before?
According to Section 36(2) of the Code on Wages, 2019, what happens if there is no available surplus for a particular accounting year?
The court may compel attendance of any person to whom a summons has been issued, for this purpose a maximum fine can be imposed to the tune of-
Coparcenary property of a Hindu: