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 embedded sql what are its advantages?

1018

---

What is the default isolation level in sql server? : Transact sql

1011

---

Are stored procedures faster than queries?

930

---

Explain dml and ddl?

969

---

What do you mean by “trigger” in sql?

1058

---

What is index example?

995

---

What is cost in sql execution plan?

968

---

How many sql databases can you have on one server?

1064

---

What is the importance of sqlcode and sqlerrm?

1334

---

Is record in pl sql?

954

---

Is pl sql useful?

971

---

What is a sql trace file?

1013

---

How does sql profiler work?

1004

---

how many values can the set function of mysql take? : Sql dba

970

---

What are the advantages of stored procedure?

994

---