JAVA INTERVIEW QUESTIONS

In SQL, we have, seen that, we can add conditions by using WHERE command, during any SELECT, UPDATE or DELETE operation. Now, what about multiple conditions? For that, SQL provides to add multiple condition by using AND command. it can be used as many times as you want.

Syntax: SELECT [column_name] FROM [table_name] WHERE [condition_1] AND [condition_2];

[Note: AND means mandatory condition, that means, the operation has to always fulfill the criteria provied under AND block. ]

Example:

Again, use the same table, we will see the usage of  AND command.
Employee Details ( employee_details), which contains 
Employee ID ( emp_id), 
Employee Name (emp_name), 
Employee Address (emp_address) and
Employee Role: (emp_role).

Table:  employee_details 







Now, using AND command, we will SELECT those tuple, WHERE emp_role is 'Developer' and emp_address is 'Park Street, Kolkata'.
So, the query will be :

SELECT * FROM employee_details WHERE emp_role = 'Developer' AND emp_address = 'Park Street, Kolkata';

Result:




In this way, we can use multiple conditions on an RDBMS operation.