Sql

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

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

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

PREVIOUS	NEXT

Code Example
Sql :: c# update sql statement
Sql :: create table with index mysql
Sql :: sql quote in string
Sql :: object dependencies in oracle
Sql :: query to find object dependencies in oracle
Sql :: rename column name sql server
Sql :: how to delete a table in mysql
Sql :: view table mysql
Sql :: sample clause in sql
Sql :: SQL check if record exist
Sql :: SQL COUNT() With HAVING Clause
Sql :: sql server pivot rows to columns
Sql :: postgre insert select
Sql :: sql server delete table
Sql :: sql select if two columns are equal
Sql :: sql online compiler
Sql :: full join sql
Sql :: mysql time
Sql :: postgresql in array
Sql :: count the table indatabase
Sql :: oracle sql generate list of days
Sql :: SQL Rename Column in a Table
Sql :: mysql if else
Sql :: sql where contains part of string
Sql :: smallint sql
Sql :: how to get parent and child record in single query using sql
Sql :: sql datum formatieren
Sql :: php get closest location by latitude longitude
Sql :: insert many to many sql
Sql :: mysql get only the field names in a table