Answer / 9896012055

select * salary from table < select max(salary) from table
order by salary;

Answer / a.swarna devi

select max(sal)from table;

Answer / havyas

select sal from table where rownum = 2 order by sal desc

How to find 1st, 2nd, 3rd highest using select select statement not using rownum

3 Answers  

---

what is dynamic SGA and static SGA

0 Answers   Oracle,

---

How to export your own schema?

0 Answers  

---

How to name query output columns in oracle?

0 Answers  

---

What is clustered table in Oracle?

0 Answers   MCN Solutions,

---

State the various uses of dbcc command?

0 Answers  

---

How to define Data Block size ?

2 Answers  

---

12. Display the client name in upper case only and in lower case only.

1 Answers   Wipro,

---

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

3 Answers   Polaris,

---

How to run create database statement again?

0 Answers  

---

Who developed oracle & when?

0 Answers  

---

what is a cartition product?

4 Answers  

---