SQL Function

 Count() Function In SQL


Count()

Count Function in SQl Is Used To Just Count The Number Of row in Table
IN SqL  COUNT() function IS Used To  returning  the number of rows that matches a specified criteria

Count()Syntax- The Basic Syntax for Count Function are As follows


SQL>SELECT COUNT(column_name) FROM table_name WHERE condition;



EXAMPLE-

SQL>SELECT COUNT(RollNo) FROM Student;




Sum  Function In SQL


SUM()
Sum  Function is used to Display The Total Sum of A Column,
Sum function are used to Display the total sum of a numeric column
NOTE- for the Sum function column should be numeric.


Sum() Syntax- The Basic Syntax For Sum Function are given Below

Sum Function Without Condition

SELECT SUM(column_name)FROM table_name;

Sum Function With Condition

SELECT SUM(column_name)FROM table_name WHERE condition;


Example OF Sum () Function

SQL Query-
SELECT SUM(Marks)FROM Student;

In Above Example It Will Display The Total Sum Of Marks Column in Student Table.






Average Function In SQL


Avg()
Average function is used to display the average value of Numeric column in SQL
NOTE- for the AVG()function column should be numeric.

Avg() Syntax-The Basic Syntax For Average Function Are given Below

Average function Without Condition

SELECT AVG(column_name)FROM table_name;

Average function With Condition

SELECT AVG(column_name)FROM table_name WHERE condition;


Example of Average Function

SQL Query-
SELECT AVG(Marks)FROM Student;

In Above Example It Will Display The Total Average Of Marks Column in Student Table






MIN Function In SQL


 MIN()
Min Function Is Used To display Smallest Record From Selected Column
To Showing The Smallest Value From a column We Use The Min Function
NOTE- for the MIN() function column should be numeric.

MIN()Syntax- The Basic syntax For Min Function Given Below

SELECT MIN(column_name)FROM table_name WHERE condition;


MIN Function Example

SQL Query-
SELECT MIN(Marks) FROM Student;

In Above Example It Will Display The Smallest Number from the Marks column in Student table.



MAX Function In SQL


MAX () 
MAX Function Is Used To display Largest Record From Selected Column
To Showing The Largest Value From a column We Use The MAX Function
NOTE- for the MAX() function column should be numeric.


MAX ()Syntax- The Basic syntax For MAX Function Given Below

SELECT MAX (column_name)FROM table_name WHERE condition;

MAX Function Example-

SQL Query-
SELECT MAX (Marks)FROM Student;

In Above Example It Will Display The Largest Number from the Marks column in Student table






First() Function In SQL

First ()
First Function Is used To Display First Record From The selected Column

First () Synatx-The Basic Synatx For First Function given Below

SELECT First (Column_name) FROM table_name;

First() Function Example

SQL Query-
SELECT First (StudentName) FROM Student;

In Above Example It will Display The First Name From StudentName column

NOTE- First() function is only supported in MS Access.



LAST() Function In SQL


LAST()
Last Function Is used To Display Last Record From The selected Column

LAST() Synatx-The Basic Synatx For Last Function given Below

SELECT LAST(Column_name) FROM table_name;


Last() Function Example

SQL Query-
SELECT LAST(StudentName) FROM Student;

In Above Example It will Display The Last Name From StudentName column

NOTE- The LAST() function is only supported in MS Access.



Post a Comment

0 Comments