Deleting the unwanted data of the table:
========================================
=> To delete the data from the table, we have a DML command which is named as "delete".
=> delete command can be used in two ways:
	1) delete with condition
	-------------------------
	Syntax:
		delete from <table-name> where <condition>;
	=> when we need to delete the particular record from the table, the above syntax can be used.
	Ex: delete from customerInfo where CId = 112233;

	2) delete without condition
	---------------------------
	Syntax:
		delete from <table-name>;
	=> because of this, we can delete all the records of the table
	but not the structure of the table.

	Ex: delete from customerInfo;

Note:
----
delete command can always work on the data of the table only.
That means it can delete the data of the table by maintaining the table structure as same.


=> To clear the screen of the CLI, we can use the below command:
	cl scr

Delete/remove the table from the database:
========================================== 
=> to delete the table from the database temporarily, we can use "drop command" which is one of the DDL command.
Syntax:
	drop working-object-name user-name-object; 

Ex: 
drop table <table-name>;

drop table customerInfo;

=> drop can delete the structure of the table
so, we cannot select the data after the drop.


1) What is the purpose of the select statement in SQL?
2) How is the insert statement used in SQL?
3) What is the role of the update statement?
4) How is the delete statement used in SQL?
5) What are the different datatypes in SQL?
6) What is the difference between CHAR and VARCHAR datatypes in SQL?
7) How does the WHERE clause work in SQL?
8) How can you use the insert statement to add a new record to the employees table?
9) How would you use the UPDATE statement to modify existing records?
10) How can you use the DELETE statement to remove the specific records?
11) Which datatype should you use to store product prices in a table?


Assignment:
===========
1) Assume there is a employee table with 10-records
The field names are:
	EmpId, EmpName, Designation, Department, Salary, Location, DateOfJoin.

Write a SQL query to display the record of the table based on the empId.