display the employees whose salary is less than average salary
select * from EMPLOYEE where sal < (select avg(emp_sal) from EMPLOYEE);display the employees whose salary is less than average salary
select * from EMPLOYEE where sal < (select avg(emp_sal) from EMPLOYEE);get all employee of salary if more than in sql
SELECT * FROM EMPLOYEES
WHERE SALARY > 10000;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
