Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What is the difference between UNION and UNION ALL SQL syntax
What is the difference between UNION and UNION ALL SQL syntax ?
✍: Guest
UNION SQL syntax is used to select information from two tables. But it selects only
distinct records from both the table, while UNION ALL selects all records from both the
tables.
Note : Selected records should have same datatype or else the syntax will not work.
2007-10-25, 4595👍, 0💬
Popular Posts:
Can you explain different software development life cycles -part II? Water Fall Model This is the ol...
What is the main difference between a Vector and an ArrayList? Java Vector class is internally synch...
what is a service contract, operation contract and Data Contract? - part 1 In the below sample we ha...
Can one change the mouse pointer in Forms? The SET_APPLICATION_PROPERTY build-in in Oracle Forms all...
Explain simple Walk through of XmlReader ? In this section we will do a simple walkthrough of how to...