Sql Count function

The COUNT function is used to count number of records in table.
Syntax is as:
SELECT COUNT(*) FROM table_name  
As in example we have table employees
id first_name last_name salary city
1 Johan Sumith 200000 Delhi
2 Ansh Kumar 300000 Mumbai
3 Sameer Seth 100000 Delhi
4 Pyush 250000 Kolkata
5 Shikha Anand 160000 Chandigarh
6 Rajeev Khatri 450000 Chennai
7 Ram Kumar 540000 Amritsar
8 Ritu Sharma 500000 Sonepat
9 Deepika Verma 360000 Chandigarh
10 Kuldeep Singh 270000 Simla



SELECT COUNT(*) FROM employees 

We get
COUNT(*)
10