Question

Create a table for employee details with employee name as
primary key and following fields:name,age,designation,
date of joining,salary. Insert at least ten rows and perform various queries
using any one comparison, logical,set,sorting,grouping operators.(kindly help me to solve this)
​

Answer 1

Answer:

You can use the COUNT function in the SELECT statement to get the number of employees, the number of employees in each department, the number of employees who hold a specific job, etc. The following illustrates the syntax of the SQL COUNT function: COUNT([ALL | DISTINCT] expression);