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) ;

Is there a 64 bit version of ssms?

0 Answers  

---

Name the operator which is used in the query for pattern matching?

0 Answers  

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---

What are sql indexes?

0 Answers  

---

Are stored procedures compiled?

0 Answers  

---

What is graph sql?

0 Answers  

---

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 Answers   HCL,

---

When the mutating error will comes? and how it will be resolved?

2 Answers  

---

From an Employee table, how will you display the record which has a maximum salary?

29 Answers   Cap Gemini, Exilant, Synechron,

---

Give me some examples of predefined exceptions.

3 Answers  

---

what is the difference between nested subquery and correlated subquery?

0 Answers  

---

How do I count rows in sql?

0 Answers  

---