Question

Find out the error in the following SQL command and correct the same. Select * from employee group by dept where sum(salary) > 2000000 ​

Answer 1

Explanation:

all the waters on the earth's surface, such as lakes and seas, and sometimes including water over the earth's surface, such as clouds

Answer 2

Answer: Invalid use of group function sum(salary)

Explanation:

Select * from employee where sum(salary) > 2000000 is wrong

Select * from employee where salary > 2000000; could be correct