over 6 years ago
Count ( ) In SQL Database this is a function which return no of rows from a table in Database . Generally this is used in SQL select statement and count the no. of records in a table .
select count ( expression_name ) from table_name where clause ;
Suppose i have a table , name is student
**Student_name** **Student_Age** **Student_Id**
Mukesh 23 1
Ayush 24 2
Suppose i want to count number of records in a table then we can do with the count ( ) function .
select count ( * ) from student ; // Output -> 2
To count distinct column_name
select count ( distinct Student_Age ) from student ; // Output -> 1
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2022 FindNerd.com. All rights reserved.
Sign up using