Group Function in JDBC

In Most of RDBMS Products we came across 5 aggregate functions they are

a)Count()
b)sum()
c)max()
d)min()
e)avg();
Example Program for Describing Aggregate Function in RDBMS with Java Applications

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import oracle.jdbc.driver.OracleDriver;
public class class1 {
public static void main(String[] args) throws Exception {
oracle.jdbc.driver.OracleDriver obj=new OracleDriver();
DriverManager.deregisterDriver(obj);
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "system", "system123");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select count(*),sum(sal),max(sal),min(sal),avg(sal) from emp");
while(rs.next())
{
System.out.println(rs.getString(1)+"    "+rs.getString(2)+"      "+rs.getString(3)+"     "+rs.getString(4)+"    "+rs.getString(5));
}
}
}