Skip to main content

Union,Union all, Intersect and Minus

MINUS

SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE
MINUS
SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE;





INTERSECT




SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE
INTERSECT
SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE;









UNION




SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE
UNION
SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE;









UNION ALL




SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE
UNION ALL
SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE;











































Comments











Post a Comment



















Popular posts from this blog





















Behavior Driven Development




























 Behavior Driven Development (BDD) is a development process that originally associated with Test-Driven Development (TDD).    BDD is written in a readable format in an understandable language for anyone involved in software development.    BDD Features    Providing better readability and visibility.   Verifying the software against customer requirements.   Assure the implementation of the system is correct.  Derives examples of different expected behaviors of the system.  Uses examples as acceptance tests.  Focus on customer requirements throughout the development.      BDD Practice     There are two practices in BDD:-     Specification by Example (SbE).  Test-Driven Development (TDD).    Specification by example (SbE) uses examples in conversation to illustrate the business rules and the behavior of the software.     This uses to have a better understanding for Business Analyst, Product Owners, Testers and the Developers to reduce the misunderstanding abou...




















Post a Comment









Read more