Search Tutorials

Latest Questions

Failed to run Online Quiz Application in JSP
Hi, I have been following your following link to run the online quiz application, but I failed to get the result scre
Pass by Reference
Hi Friends, What is Pass by value and Pass by Reference?can u please explain with examples.is java supports Pass by r
no driver
i am having problem connecting to DB2 database fro netbeans: program: import java.sql.*; import java.lang.*; i
min project with vb
i have do the min project with VB Frantend and oracle backend
Some additions for my previous question
This is the question I posted several hours ago: "I'm trying to write a program that has a text field for input, two bu
Writing a GUI program
Hello everyone! I'm trying to write a program that has a text field for input, two buttons and the output text area. A
How to display current date in textbox
Hi guys, I'm really need your help. This is my source code. <% if (status.equals("pending") && penanda==0)
Methods in Java
Hello. Currently i am involved in a group project and we have each been given a specific part of code to create our joi
how to record qvga video using j2me
hello if it is possible how i can record qvga video usin j2me?
how to record qvga video using j2me
hello if it is possible how i can record qvga video usin j2me?
All Questions...

Comments

Aggregate Functions
In this section, you will learn how use of the aggregate functions.

Aggregate Functions

In this section we are going to illustrate aggregate function, with the help of which we can use many arithmetic operation like average, count, maximum and many more in SQL. They are briefly described and denoted by the keyword in the given below section.

AVG
COUNT
MAX
MIN
SUM

For all of the above given function the standard code syntax will be:

SELECT "function type" ("column_name") FROM "table_name"

For example we just take a Employee table and use the aggregate function SUM on the field "Salary" to find out the total salary of the Employee table.

Table Employee:

emp_Name Salery Joining_Date

Amit 15000 Feb-05-2005

Chandan 25000 Feb-17-2005

Ravi 8000 Feb-25-2005

Vinod 7000 Feb-28-2005

To find out the total salary of the company's employee we should write the following code:

SELECT SUM (Salary) FROM Employee;

When we run the above query we will get the following result:

SUM(Salary)

55000

ť View all related tutorials

Related Tags: sql mysql c string function fun io sed char return character unc cte to e use from left in m

Leave your comment:
Name:
Email:
URL:
Title:
Comments:
Enter Code:
	Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted. No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.