consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

---

after tell procedure whole code he asked can i write the same way in a function

3 Answers  

---

How can you fetch common records from two tables?

0 Answers  

---

Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,

---

what is sub-query? : Transact sql

0 Answers  

---

---

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

0 Answers  

---

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

---

Can we edit a view in sql?

0 Answers  

---

Which is better join or inner query?

0 Answers  

---

How you improve the performance of sql*loader? : aql loader

0 Answers  

---

What is the difference between instead of trigger and after trigger?

0 Answers  

---

Main diff between varray and nested tablea

3 Answers   Polaris, TCS,

---