How to find only %th Highest Sal

6 Answers   Infogain, Symphony,

---

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

---

what is the difference between union and union all

14 Answers   IBM, Luxoft, Oracle,

---

What is record data type?

0 Answers  

---

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

---

---

What is difference between db2 and sql?

0 Answers  

---

how to retrive only second row from table?

31 Answers   IBM,

---

can i create trigger on synonym is it possible or not please help me

4 Answers   CGI,

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

---

What is secondary key?

0 Answers  

---

Explain lock escalation? : Transact sql

0 Answers  

---

can we create index on index?

7 Answers   iFlex, Symphony,

---