Query to retrive the second AVERAGE Column from the table

madduri_25 · New User Joined: 09 Mar 2005 Posts: 3

hai all,
pls reply with sql query how we retrieve the second avg value from column of a particular table is there any sutable query pls fwd it
regards
madduri_25 team

priyesh.agrawal · Posted: Fri Apr 29, 2005 4:26 pm

Second Avg means what....will you be please more clear.......

Regards,

Priyesh

ovreddy · Posted: Wed May 04, 2005 1:49 pm

Hi Madduri,

Average is a group function which gives a single result by taking a group of rows as input. So we will have only one average for a column. Please clarify us about your question in more detail.

Eg: select avg(sal) from myuser.emp;

Returns average of salary which is only one value. So what is the second average vale?

Thanks,
Reddy.

ssowjanya · New User Joined: 29 Apr 2005 Posts: 13

Hi Madduri,
Is the query is like this...
write a query to find the second max sal?

nrsmca · New User Joined: 25 May 2005 Posts: 14

Hi,

Select avg(salary) from Table1 a where 2 =
(select count (*) from Table1 b where b.salare >= a.salary);

N th Max. Avg value calculation,
Select avg(salary) from Table1 a where n =
(select count (*) from Table1 b where b.salare >= a.salary);

Regards,
N.R.S,mca

ovreddy · Posted: Wed Jun 15, 2005 3:01 pm

Hi NRS,

Sorry I am not getting. What you are trying for. U mean to find the average of salries after exclusing the highest salary. But as I know there is no concept of second average??? If I am wrong please correct me with explanation.

Thanks,
Reddy.