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;

what is the difference between delete and truncate commands? : Sql dba

1068

---

What are database links used for?

1044

---

Explain what is a database?

1083

---

What is group by in sql?

1083

---

Explain isolation levels. : Transact sql

1068

---

What is pivot table in sql?

1103

---

What are the advantages of indexing?

982

---

what is meant by nl2br()? : Sql dba

1031

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1094

---

What is the difference between alter trigger and drop trigger statements?

1103

---

what is the difference between union and union all? : Sql dba

1018

---

Write the command to remove all players named sachin from the players table.

1182

---

What is pl/sql table? Why is it used?

1037

---

what is the difference between group by and order by in sql? : Sql dba

1127

---

How to add a column ‘salary’ to a table employee_details?

1012

---