forum

Home / DeveloperSection / Forums / get average value form table

get average value form table

Anonymous User210511-Mar-2013

Hi Everyone!

I have a table (tblEmployee) as per bellow

ID Name  Salary
-- -----  ------
1 Mark   15000
2 Samuel  20000
3 Ethon  26000
4 Gotibandhu 15000

I want to select table data based on average value of column

e.g. average of table is

2 Samuel 20000

Thank in advance!

Updated on 11-Mar-2013

I am a content writter !

Can you answer this question?

Answer

11-Mar-2013

Hi Ezra!

You can get table data using nested query or sub query, as following

select * from [tblEmployee] where [salary] = (select avg(salary) from [tblEmployee])