Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 181305 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / infant gerald
Join is a And Statement of a where clause
Unios is an Or Statemen of matching datatype
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / krish
how to fine top 3 emp(sal) from each deptno
i want the out put like this
sal deptno
100 20
200 20
300 20
150 30
250 30
350 30
so top 3 from each dept
thank u
| Is This Answer Correct ? | 1 Yes | 5 No |
Answer / vishnu e s
join-is used to join two tables which have the same field
and same data type.
union-is to join two sql querrys....
| Is This Answer Correct ? | 3 Yes | 8 No |
Answer / sompalli krishna
Join: joins are used to combine the columns from one or
more tables(join using one table is possible for self
join).output should B more than one column.
It is constraint based.Columns r joined based on similar
column names and datatypes also on both the tables.
union: union is used to combine the columns from one or
more tables.Output should B one column.
It is not constraint based.Any no. of columns can be
combined without using any condition.But the data types
should be same immaterial to column names.
Contact me for any queries on 09885790989
| Is This Answer Correct ? | 0 Yes | 5 No |
Answer / vijay kulkarni
In Join, matching rows are joined side-by-side to make the
result table but whereas in Union rows are joined one-below
the other to make the result table.
| Is This Answer Correct ? | 21 Yes | 33 No |
Answer / sat kumar
Union:- Union return the common data in the form of rows
Join:- Joins always returncommon Data in the form of Column
if oyu have some suggetion about this then plz call
me at this is my no
+91-9868591907
| Is This Answer Correct ? | 19 Yes | 35 No |
Answer / venki
A join is used to combine rows from multiple tables. A join
is performed whenever two or more tables is listed in the
FROM clause of an SQL statement.
Combines the results of two SELECT statements into one
result set, and then eliminates any duplicate rows from
that result set
| Is This Answer Correct ? | 40 Yes | 57 No |
what is the difference between stored procedure and packaged procedure
What is the differnce between view and materialized view
Explain foreign key in sql?
How to connect a sql*plus session to an oracle server?
Why is stored procedure faster than query?
Define implicit and explicit cursors.
HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?
How much does sql certification cost?
What is mutating trigger?
is it mandatory to select all the column in a view then what columns should be selected
What is left join in postgresql?
How is data stored on a disk?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
