explain primary keys and auto increment fields in mysql : sql dba

0 Answers  

---

Can we use views in stored procedure?

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,

---

How to find last day of the month in sql query

4 Answers  

---

What is a temporal table?

0 Answers  

---

What are the types of dbms?

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

Can we write ddl statements in functions?

0 Answers  

---

Is there any restriction on the use of union in embedded sql?

0 Answers  

---

How do we tune the code?

2 Answers  

---

Why function is used in sql?

0 Answers  

---

What are the usage of SAVEPOINTS?

5 Answers  

---