What is different between union and minus?
Answer Posted / pravin
Union combines the two table records, its eliminates
the duplicate records. while minus shows only those rows
which are not dulicated of table first in query.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How do I know if I have sql express or standard?
Is null operator in sql?
What are all the common sql functions?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
How do I restart sql?
What found sql?
What port does sql server use?
What are the usages of sql?
What is pl sql in oracle?
What is the starting oracle error number?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Is coalesce faster than isnull?
How to use sql*plus built-in timers?
What is posting?
Can we join tables without foreign key?