Saturday, August 1, 2015

SQL tutorial - lesson 13 - count function

If you want to count the number of rows matching the given condition or if you want to see the number of rows that matches a specified criteria then you can use count function

syntax:

select count(employee id) as total employee from emp;

when you run the above statement  it will count the number of employee ids and it will return the  total count from the emp table.


No comments:

Post a Comment