Software Testing

ads
ads

Popular Posts

COUNT


The Count() Function return the number of rows that match specified criteria.
The basic syntax is as follows:
SELECT COUNT(Column_Name) FROM Table_Name
Syntax For SQL:
SELECT COUNT(Salary) FROM Employee
Emp_idNameSurnameSalaryDept_id
1RajeshKhanna450002
2SnehaGupta550004
3SandeepNehte950001
4KirtiPatil250003
5NileshJadhav450003
6DipeshDas350005
7KailashRane620001
8KavitaDeshpande480003
9SanjayDatt500003
10ShrutiHasan780001

After Execute: 
Count(Salary)
10

No comments:

Post a Comment