3. Using Functions : Step 1

Demo

Show the number of Employees

The function count() will return the number of records. We can use this to output the total number of records in a table with the following SQL:

SQL

SELECT COUNT(*) FROM emp

Output

COUNT(*)
14

Progress

Proceed to Next step