compound operator in sql 1

compound operator in sql

SELECT name_emp,salary, age  FROM DataFlair_Employee WHERE age>27 AND salary>25000;

Here is what the above code is Doing:
1. We are selecting the name_emp, salary, and age columns from the DataFlair_Employee table.
2. We are selecting only those rows where the age is greater than 27 and the salary is greater than 25000.

Similar Posts