What is rank dense_rank and partition in sql?

0 Answers  

---

What is trigger in flip flop?

0 Answers  

---

what are the different type of sql's statements ? : Sql dba

0 Answers  

---

is it possible to pass an object or table to a procedure as an argument?

0 Answers  

---

What is sql lookup?

0 Answers  

---

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

4 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,

---

What sql database should I use?

0 Answers  

---

How to maintain the history of code changes of pl/sql?

3 Answers  

---

what is union? : Sql dba

0 Answers  

---

what is the use of HASH, LIST partitions?

1 Answers   ITC Infotech,

---

explain the delete statements in sql

0 Answers  

---