Answer / manish_patil

select sal from emp_sal where rownum = 3 order by sal desc

Answer / tushar

select max(sal) from ( select sal from emp group by sal order by sal) where rownum<4;

Answer / nagendra

select min(sal) from emp where sal in( select top 3 sal
from emp order by sal desc)

What is a join?

0 Answers  

---

What is the use of partition by in sql?

0 Answers  

---

can sql servers linked to other servers like oracle? : Sql dba

0 Answers  

---

how to get help information from the server? : Sql dba

0 Answers  

---

What company owns postgresql?

0 Answers  

---

---

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

---

how to run 'mysql' commands from a batch file? : Sql dba

0 Answers  

---

How many developers work on postgresql?

0 Answers  

---

How can you select unique records from a table?

0 Answers  

---

Can we have two clustered index on a table?

0 Answers  

---

Why is a primary key important?

0 Answers  

---

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

---