Answer Posted / anonymous

select min(salary) from(
select salary from test
order by salary desc
)
where rownum<4



For ORACLE 8i,9i,10g


select distinct salary from
(select salary,
dense_rank() OVER (PARTITION BY empname ORDER BY salary
desc) rank
from test) where rank=7
;

What do you understand by intent locks?

952

---

what is datawarehouse?

1049

---

What is catalog views?

1021

---

Where the sql logs gets stored?

931

---

What is the use of keyword with encryption. Create a store procedure with encryption?

899

---

Explain what is analysis service repository?

922

---

Define full outer join in sql server joins?

909

---

What is an indice?

979

---

What do you know about normalization and de- normalization?

869

---

How you can find out if an index is useful to the optimizer?

869

---

What are transactions and its controls?

1002

---

What is a non-clustered index?

949

---

explain extended properties

926

---

What is left outer join in sql server joins?

965

---

plss anybody specify tha constrian management system in dbms

2078

---