Search
 
SCRIPT & CODE EXAMPLE
 

SQL

FIND AVERAGE SALARY EARNER IN SQL

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

find below average salary in sql

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

PREVIOUS NEXT
Code Example
Sql :: mysql vs postgresql 
Sql :: q operator in plsql 
Sql :: mysql: command not found 
Sql :: oracle dba_dependencies 
Sql :: oracle view dependencies 
Sql :: SQL Add Column in a Table 
Sql :: sql time format 
Sql :: list table columns mysql 
Sql :: sample in sql 
Sql :: mysql function 
Sql :: GROUP BY With HAVING Clausel 
Sql :: pivot 
Sql :: sql remove duplicates 
Sql :: mysql show create table 
Sql :: ON DUPLICATE KEY UPDATE for postgres 
Sql :: @firebase/database: FIREBASE WARNING: update at /users failed: permission_denied 
Sql :: mysql disable logging 
Sql :: mysql default value 
Sql :: multiple count with where clause sql 
Sql :: not regexp_like in oracle 
Sql :: mssql-cli usage 
Sql :: consecutive numbers sql 
Sql :: osm2pgsql mac 
Sql :: sql stored procedure with table parameter 
Sql :: how to export/import a mysql database via ssh 
Sql :: increment id in mysql 
Sql :: How to search for a String in all Columns in all tables in SQL Server Database 
Sql :: postgres having 
Sql :: remove root password mysql 
Sql :: php5-mysql has no installation candidate 
ADD CONTENT
Topic
Content
Source link
Name
6+3 =