Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Display average marks of students using avg() function and also round it using round().

Posted By: Adalfredo Fischer     Category: Oracle     Views: 6002

Display average marks of students using avg() function and also round it using round().

Code for Display average marks of students using avg() function and also round it using round(). in Oracle

select rollno,round(avg(marks),2) from sc;

Output:

    ROLLNO  ROUND(AVG(MARKS),2)
----------  -------------------

         1               78.20
         2               78.60
         3               95.40
         4               64.80
         5               72.80
  
Share: 

 
 
 


Adalfredo Fischer
Adalfredo Fischer author of Display average marks of students using avg() function and also round it using round(). is from Frankfurt, Germany.
 
View All Articles

Related Articles and Code:


 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!