Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pavan_1981
UNION:set of all rows selected by both queries excluding
duplicates rows.
UNIONALL:set of all rows selected by both queries including
duplicate rows.
MINUS:set of all rows present in the first query and not
present in the second query.
INTERSECT:set of all rows commonly returned by both the
queries.
| Is This Answer Correct ? | 20 Yes | 4 No |
Post New Answer View All Answers
Is sql port 1433 encrypted?
What has stored procedures in sql and how we can use it?
Define concurrency control. : Transact sql
What is sql server and ase?
What is the process of debugging?
How to connect a sql*plus session to an oracle server?
Where the sql database files are stored?
How do I run a sql script?
What is mdb stand for?
What are functions in sql?
What is a natural join sql?
What's the difference between inner join and left join?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
how to enter characters as hex numbers? : Sql dba
What is the largest value that can be stored in a byte data field?
