Answer / rupali

Its all depend upon network, table structure, server load

How do I view a sql trace file?

0 Answers  

---

What is sql and db2?

0 Answers  

---

write a query to delete similar records in same table

13 Answers   TCS,

---

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

---

What are the types of operators available in sql?

0 Answers  

---

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

---

How do I write a cron which will run a sql query and mail the results to agroup?

0 Answers  

---

How do I partition in sql?

0 Answers  

---

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---

Fetch an entire row from the employees table for a specific employee ID:

2 Answers  

---

What are all the different normalization?

0 Answers  

---

What is difference between cursor and ref cursor?

1 Answers  

---