What are the query optimization techniques?

0 Answers  

---

What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

0 Answers  

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

What's the difference between a primary key and a clustered index?

0 Answers  

---

---

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

Does sqlite need a server?

0 Answers  

---

Can we change the table name in sql?

0 Answers  

---

Is sql scripting language?

0 Answers  

---

How can you know that statistics should be updated?

0 Answers  

---

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

what is a trigger in mysql? : Sql dba

0 Answers  

---