Difference between union and union all?
1. UNION only selects distinct values and UNION all selects all values.
2. UNION filters duplicates values and UNION ALL does not.
Simple example to test it:
create table foo(
foo_id number,
foo_name varchar2(30)
);
insert into foo values(1,'FAWAD');
insert into foo values(1,'NAZIR');
select * from foo
union
select * from foo;
select * from foo
union all
select * from foo;
Subscribe to:
Post Comments (Atom)
Using Handlebar Prompt in Semantic Kernal
> dotnet add package Microsoft.SemanticKernel.PromptTemplates.Handlebars --version 1.30.0 using Microsoft . SemanticKernel ; using Micr...
-
LINK: http://www.techonthenet.com/oracle/functions/nvl.php Oracle/PLSQL: NVL Function In Oracle/PLSQL, the NVL function l...
-
Setting up a MPI cluster on Ubuntu involves the following steps: 1. Install OpenMPI on all machines. $sudo apt-get install libopenmpi-de...
-
Very Useful Link: http://people.cc.ku.edu/~grobe/intro-to-LSL/index.html#particle Using the Linden Script Language This page is a short...
No comments:
Post a Comment