Answer / infant gerald

Join is a And Statement of a where clause
Unios is an Or Statemen of matching datatype

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

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....

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

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.

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

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

What is user defined functions?

0 Answers  

Why query optimization is needed?

0 Answers  

What is the difference between count 1 and count (*) in a sql query?

0 Answers  

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

What's the difference between inner join and left join?

0 Answers  

Can we create a trigger on view?

0 Answers  

What are properties of the transaction?

0 Answers  

What is a .db file?

0 Answers  

How many types of normalization are there?

0 Answers  

Does a user_objects view have an entry for a trigger?

0 Answers  

How can we make an if statement within a select statement?

0 Answers