Answer Posted / debanjan rudra

select sal from (select sal from emp order by val desc)
where rownum < 4;

What is the difference among union, minus and intersect?

1009

---

how to calculate expressions with sql statements? : Sql dba

1045

---

How to read/write files from pl/sql?

1047

---

how to create a test table in your mysql server? : Sql dba

1018

---

How to connect a sql*plus session to an oracle server?

1136

---

What do you understand by case manipulation functions?

1040

---

Are subqueries better than joins?

981

---

Is natural join and inner join same?

932

---

Is there any restriction on the use of union in embedded sql?

1164

---

Write a sql query to get the third highest salary of an employee from employee_table?

1077

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2506

---

How do you declare a constant?

968

---

How do you declare a user-defined exception?

1031

---

What are the most important characteristics of pl/sql?

1168

---

Is sql the best database?

984

---