adspace


What is union?

Answer Posted / Rupesh Kumar

The UNION operator combines rows from two or more SELECT statements and returns the result as a single table. It can be used when you need to combine the results of multiple queries, but the structure (number of columns and their names) must be identical.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can delete statement be rollbacked?

1065


what is sql server agent? : Sql dba

1188


Can we rollback truncate?

1083


If a cursor is open, how can we find in a pl/sql block?

1252


what is bcp? When does it used? : Sql dba

1065


how to escape special characters in sql statements? : Sql dba

1124


what are all the common sql function? : Sql dba

1141


What is your daily office routine?

2352


what is dbms? : Sql dba

1070


what is schema? : Sql dba

1163


what are the advantages of sql ? : Sql dba

1154


how to start mysql server? : Sql dba

1279


Is primary key clustered index?

1027


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2101


what is collation? : Sql dba

1242