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

Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

---

Can we use pl sql in mysql?

0 Answers  

---

What packages are available to pl/sql developers?

0 Answers  

---

What is write ahead logging in sql server?

0 Answers  

---

what is union, minus and interact commands? : Sql dba

0 Answers  

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---

write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,

---

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers   Polaris,

---

how many tupples can insert in 1 second in sql

1 Answers  

---

How to read/write files from pl/sql?

0 Answers  

---

what is the bond code in materialized view?

0 Answers  

---

Is sqlite thread safe?

0 Answers  

---