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
;

Explain the dirty pages?

1054

---

What are translations and its use? : sql server analysis services, ssas

1085

---

Explain system views?

1133

---

What is a full text index?

970

---

What is the index requirement in SQL Azure?

98

---

What is dirty page?

1036

---

Explain the xml support sql server extends?

1083

---

Do you know what are the restrictions that views have to follow?

1129

---

How to create a large table with random data for index testing in ms sql server?

1071

---

How to create prepared statements using odbc_prepare()?

1106

---

What are click through reports?

149

---

How to find table changes in sql server?

1177

---

What is a periodical index?

979

---

What is a scheduled job or what is a scheduled task?

1012

---

Can one drop a column from a table?

1069

---