Answer Posted / sambu

select r.sal,r.rank,r.dept high from
(select deptno,sal,dense_rank() over (partition by deptno
order by sal desc) rank
from emp) r
where r.rank=3;


The above query gives the following result

DEPTNO SAL HIGHEST
------ ----- -------
10 1300 3
20 1100 3
30 1500 3

Is sqlexception checked or unchecked?

975

---

What is difference between db2 and sql?

1009

---

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.

7367

---

What is rownum in sql?

1052

---

How do you get column names only for a table (sql server)?

1175

---

What is sql constant?

1040

---

What is sql and also describe types of sql statements?

1072

---

What are the three pl sql block types?

1016

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1025

---

What is a temp table?

1033

---

How would you convert date into julian date format?

1010

---

How do you rank data in sql?

1012

---

What is duration in sql profiler trace?

1089

---

How do you write a subquery?

1035

---

What is the difference between alter trigger and drop trigger statements?

1118

---