/SQL/Average salary in sql

Average salary in sql

Average salary in sql

SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY = (SELECT AVG(SALARY) FROM EMPLOYEES);

0

Find below average salary in sql

SELECT first_name, salary FROM employees
WHERE salary <= (SELECT AVG(salary) FROM employees);

0

FIND ABOVE AVERAGE SALARY EARNER IN SQL

SELECT FIRST_NAME, LAST_NAME
FROM EMPLOYEES
WHERE SALARY > (SELECT AVG(SALARY) FROM EMPLOYEES);

0

Similar codes

10 votes212 views2 answers
Tsql merge example
SQL
0 vote192 views1 answer
Soql more than today
SQL
0 vote199 views1 answer
How to execute stored output to csv files
SQL
0 vote201 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
2 votes195 views1 answer
How to create sql database
SQL
19 votes219 views6 answers
Create table sqlite
SQL
0 vote191 views1 answer
Renommer table sql
SQL
2 votes203 views3 answers
Mysql list tables by size
SQL
-1 vote185 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote207 views1 answer
Logtash mysql cofiguration file
SQL

Share