A table has the following columns and values
Plant, Empname, Post,Salary
I have to write a select statement which returns only those rows where plant is not equal to 'Det' if Post is 'Manager'
Is it posible to write a single select without using Minus or Except.
I got the required results by writing the following select statement.
Select Plant,EmpName,Post,Salary from table
select Plant,Empname,Post,Salary from table where
Plant = 'Det' and Post='Manager"
Is it possible get the results without using the Minus.
Thanks in advance.