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.
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