How to find greater than average salary records in MySQL

MySQL Interview Queries MySQL Database MySQL Query AVG Function in SQL

Find the greater than average salary records in mysql by using AVG function. as per below example average salary is 5000

SELECT * FROM employee;

    id  name    salary  
------  ------  --------
     1  Ramesh      5000
     2  Ashish      4000
     3  Rahul       6000
     4  Vishal      7000
     5  Harsh       3000

Get the greater than average salary records in MySQL

SELECT * FROM employee WHERE salary > (SELECT AVG(salary) FROM employee);

Output ::

    id  name    salary  
------  ------  --------
     3  Rahul       6000
     4  Vishal      7000

Top Articles

1- How to get total number of records of table in mysql

2- How to Sort an array of associative arrays by value of given key in php

3- Destructuring assignment in JavaScript

4- String Concatenation in JavaScript

5- Tag Template literals (Strings) in JavaScript

6- Difference between null and undefined in JavaScript

7- localStorage, sessionStorage and cookies in JavaScript?

8- find the nth highest salary in mysql without limit

9- How to find greater than average salary records in MySQL

10- how to find duplicate records in MySQL query

11- How to use second index forcefully in MySQL

12- How to get total number of rows in MySQL table with and without count

13- Difference between where and having clauses

14- What is the difference between CHAR and VARCHAR ?

15- How to copy structure and data from one table to another table in MySQL

16- How to delete duplicate records in MySQL

17- Difference between DELETE, TRUNCATE and DROP commands in SQL

18- Difference between Union, Union all, INTERSECT and MINUS

19- ACID Properties in DBMS

20- What is a MySQL index and types of Index ?