Home » RDBMS Server » Server Administration » Re: Please Help : How to Average
Re: Please Help : How to Average [message #373191] Tue, 03 April 2001 08:20
Balamurugan.R
Messages: 91
Registered: March 2001
Member
Hi,

This is another easy way u can use this,

select stud_id,
(nvl(maths,0)+nvl(physics,0)+nvl(english,0)+nvl(chemistry,0))/(decode(maths,null,0,1)+decode(physics,null,0,1)+decode(english,null,0,1)+decode(chemistry,null,0,1)) from stud_table;

Hope this can help u.

With regards,
Balu

Report message to a moderator

Previous Topic: Re: Please Help : How to Average
Next Topic: Re: Trigger
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 01:28:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.