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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!