Answer / justin

SELECT sal FROM empORDER BY sal DESC LIMIT 2 , 1

Answer / purushotham

select level,max(sal)
from table
where level=3
connect by prior sal>sal
group by level

Answer / mousumi dalai

select min(sal) from emp where sal in
(select sal from emp order by sal desc where ROWCOUNT <=3) ;

How can I make sql query run faster?

0 Answers  

---

How do temporal tables work?

0 Answers  

---

What do you mean by stored procedures? How do we use it?

0 Answers  

---

How many postgresql users are there, worldwide?

0 Answers  

---

How do I sort a table in sql?

0 Answers  

---

---

What is the difference between explicit and implicit cursors in oracle?

0 Answers  

---

how to shutdown mysql server? : Sql dba

0 Answers  

---

Can a varchar be a primary key?

0 Answers  

---

Does varchar need length?

0 Answers  

---

Explain what is table in a database?

0 Answers  

---

What is dynamic query?

0 Answers  

---

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

2 Answers  

---