Answer Posted / vinodkumar

select *from(select *from emp orderby sal desc)where
ronum<=2 minus select *from (select *from emp order by sal
desc ) where rownum<=1;

How many types of keys are there in sql?

986

---

What is pl sql and why it is used for?

1070

---

How do I view a table in sql?

948

---

Is ms sql traffic encrypted?

872

---

What is the use of count (*) in sql?

980

---

Can variables be used in sql statements?

980

---

Explain what is a column in a table?

1041

---

Explain character-manipulation functions?

1067

---

What is the difference between having clause and where clause?

1009

---

Explain constraints in sql?

981

---

What are the different types of database management systems?

950

---

Can you call pl/sql package functions from within a fast formula?

974

---

What is difference between function and trigger?

969

---

How many types of triggers exist in pl/sql?

1009

---

Why is a trigger used?

888

---