Translate to Tamil

Upto 25% Offers

Best Offers

Bigbasket [CPS] IN

Amazon Best Offers

Amazon Offers

Offers

Online Income

Best Online Offers

Wikipedia

Search results

Wednesday, 20 April 2011

SQL Count

The COUNT() function returns the number of rows that matches a specified criteria.

The COUNT(column_name) function returns the number of values (NULL values will not be counted) of the specified column:


Syntax 
SELECT COUNT(column_name) FROM table_name



custcode
custname
city
qty
rate
1
Siva
Srivilliputtur
50
70
2
Bala
Sivakasi
30
56
3
Kanna
Madurai
100
200
4
Vijay
Chennai
30
30
5
Kodee
Sandnes
60
80
5
Kodee
Srivilliputtur
60
30

Example : 1

SELECT count(*)  as NoofRecord FROM Custmast

Output :

NoofRecord
         6

Example : 2

SELECT count(Custname)  as NoofRecord FROM Custmast

Output : 

NoofRecord
       6

Example : 2

SELECT count(Distinct Custname)  as NoofRecord FROM Custmast

Output : 

NoofRecord
        5

    * Distinct Same name  or  Dublicate Record Not Allowd ( custname --> kodee two time appear in the table)

 Share This Post


No comments:
Write comments

Infolinks

Services

© 2014