Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 180500 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / prasad
The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables.
The UNION operator is used to combine the result-set of two or more SELECT statements.
Notice that each SELECT statement within the UNION must have the same number of columns. The columns must also have similar data types. Also, the columns in each SELECT statement must be in the same order.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the features of pl sql?
Are subqueries better than joins?
What are crud methods?
How do we use distinct statement? What is its use?
what is auto increment? : Sql dba
Is sql low level language?
how to get a list of indexes of an existing table? : Sql dba
What is sql partition function?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What is exception? What are the types of exceptions?
Why we use stored procedure instead of query?
Is sql a dbms?
What is the difference between python and sql?
What are packages in pl sql and also explain its advantages?
What are the built in functions of sql?
