Question
Which of the following SQL queries is used to find the
second highest salary from an employee table? SELECT MAX (salary) Â Â Â Â Â Â Â FROM employee WHERE salary < ( SELECT MAX (salary) FROM employee);Solution
The query uses a nested SELECT statement to retrieve the second-highest salary from the employee table. Let's break it down:
- Inner query: SELECT MAX(salary) FROM employee retrieves the highest salary in the employee table.
- Outer query: The WHERE salary < (SELECT MAX(salary) FROM employee) ensures that only those salaries smaller than the highest salary are considered, and the outer MAX(salary) retrieves the largest salary from that set, effectively giving the second-highest salary.
- B is incorrect because the query does not return the highest salary but rather the second-highest salary by excluding the maximum salary.
- C is incorrect because nested SELECT statements are valid in SQL and do not cause errors here.
- D is incorrect because the query will return a value unless there are no records in the employee table.
- E is incorrect because the query will return a single value—the second-highest salary.
The first ever wheat variety for conservation agriculture in India is
Dual purpose breed of goat is ………….
It is a group of people that primarily interact via communication media such as letters, telephone, email or usenet rather than face to face
Ozone layer is situated in which atmospheric layer?
Pusa bedana is the variety of:Â
Indian Institute of pulse research is located at
_______ is known as biological reduction
Which of the following countries have the highest organic farmers in the world?
At what stage is the process of dehaulming typically carried out in potato farming?
Which grafting method requires making a downward vertical split on the stub for inserting the scion?