Sql

SELECT AVG(column_name)
FROM table_name
WHERE condition;

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

SELECT student_name, avg(notes) FROM student_notes GROUP BY student_name;

PREVIOUS	NEXT

Code Example
Sql :: postgresql not case sensitive where in
Sql :: mysql collation for all languages
Sql :: sql get inserted primary key
Sql :: sqlite unique
Sql :: activate event scheduler mariadb
Sql :: SQL server how to see user permissions on objects
Sql :: mysql remove first and last character from string
Sql :: row to value to json in sql server
Sql :: create table in mysql mariadb primary key foreign key
Sql :: mysql get last 2 month data
Sql :: how to create external table in hive
Sql :: postgres update with if condition query
Sql :: Converting mysql tables to charset utf8mb4
Sql :: show sql server database
Sql :: how to add month in update sql
Sql :: Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF
Sql :: lack create session privilege oracle
Sql :: mysql min value row
Sql :: query to find object dependencies in oracle
Sql :: how to find all children of a record with only parent ID in sql
Sql :: subquery in sql
Sql :: codeigniter get sql query string
Sql :: sql server convert to guid
Sql :: QL HAVING Keyword
Sql :: 2nd max salary query in sql
Sql :: create table from existing table in sql
Sql :: grant all privileges database postgres to user
Sql :: mssql server port
Sql :: uninstall mysql ubuntu 18.04 stackoverflow
Sql :: sqlite select split string