SELECT 
    employee_id,
    SUM(employee_salary) AS salaryCount,
    SUM(employee_basic) AS salarybasic
FROM
    employee
GROUP BY designation
HAVING employee_salary > 10000;

HAVING employee_salary > 10000 AND employee_designation = 'cleark'; 

              

REPLACE INTO employee(emp_id,emp_name) VALUES(23,'Rajesh');                    
                

Comment