list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

0 Answers  

---

What does “select count(1) from tab” result?

10 Answers   IBM,

---

What are analytic functions in sql?

0 Answers  

---

Do we need to create index on primary key?

0 Answers  

---

What is set transaction?

0 Answers  

---

---

How to select unique records from a table?

0 Answers  

---

What are dml commands?

0 Answers  

---

I want to know last five transactions or records from emp table, from now?

11 Answers   Wells Fargo,

---

what is unique key constraint? : Sql dba

0 Answers  

---

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,

---

How to use sql statements in pl/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,

---