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
;

How to list all user names in a database?

1006

---

Define the one-to-one relationship while designing tables.

858

---

how to define testing of network layers? : Sql server database administration

911

---

How you provide security to cube? : sql server analysis services, ssas

924

---

what are database files and filegroups? : Sql server database administration

888

---

what is unique and xaml nonclustered index

998

---

How to apply filtering criteria at group level with the having clause in ms sql server?

947

---

What is service broker?

957

---

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1163

---

What is difference between equi join and inner join?

860

---

What are the dis_advantages of stored procedures, triggers, indexes?

2173

---

How to create a new login name in ms sql server?

998

---

Explain the properties of sub-query in sql server?

956

---

What is the sql profiler?

901

---

What is explicit mode in sql server?

1019

---