Netsparker Web Application Security Scanner

SQL UNION

(adsbygoogle = window.adsbygoogle || []).push({});

In previous article we have learned about SQL JOINS. In this section of Software Testing Class we are concentrating on “SQL UNION”. In this post we are covering what is SQL UNION, examples of UNION, why use SQL UNION & difference between SQL JOIN and UNION.

 

What is a SQL UNION?

The SQL UNION operator allows you to combine the result of two or more SQL SELECT queries.

The only requirement to work

Continue reading…

SQL JOIN's

(adsbygoogle = window.adsbygoogle || []).push({});

The JOIN is very much misunderstood term for beginners while learning the SQL commands. In the interview at least one question is ask about the SQL JOIN’s. So in this article I am trying to simplify the things for new SQL learners & make it easy to understand the SQL JOIN’s. At the end of this post you should in a position to write your SQL JOIN query independently. So first start from the

Continue reading…