How many rows will return from dual table?

4 Answers   Fujitsu,

---

How many joins in sql?

0 Answers  

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---

what is the difference between a having clause and a where clause? : Sql dba

0 Answers  

---

How do you identify a primary key?

0 Answers  

---

---

what is the difference between union and union all? : Sql dba

0 Answers  

---

what is row? : Sql dba

0 Answers  

---

Is primary key clustered index?

0 Answers  

---

what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3 Answers   3i Infotech,

---

What is the difference between view and stored procedure?

0 Answers  

---

What are the advantages of stored procedure?

0 Answers  

---

What is primary key and foreign key?

0 Answers  

---