Answer Posted / manoj

SELECT min(salary)
FROM (
SELECT e.salary , ROWNUM
FROM emp e
ORDER BY salary DESC
AND ROWCOUNT <=3
)
ROWNUM =3;

What is the difference between join and natural join?

907

---

What is a composite primary key?

1050

---

what is a database transaction? : Sql dba

1134

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3962

---

What is raw datatype in sql?

1007

---

what is oltp (online transaction processing)? : Sql dba

1039

---

What is an invalid partition table?

981

---

Is full outer join same as cross join?

935

---

What is materialized view in sql?

889

---

What is an example of translating a date into julian format?

1066

---

Does asenumerable execute the query?

1009

---

Explain the steps needed to create the scheduled job?

988

---

What is hibernate and its relation to sql?

1083

---

What are the two parts of design view?

988

---

What is rank () in sql?

906

---