Answer Posted / shriram

You can also do it by the following query ..

select * from (select name,salary,rank() over(order by
salary desc as r) from employee) where r = 2;

The above query returns the 2nd highest salary from the table.

What is primary key in db?

1004

---

Does google use sql?

952

---

Why is %isopen always false for an implicit cursor?

1100

---

explain normalization concept? : Sql dba

1045

---

What is a subquery in sql?

1036

---

how to use like conditions? : Sql dba

1105

---

Explain architecture of sql server notification services?

1054

---

How do I know if I have sql express or standard?

1028

---

what is the difference between undefined value and null value? : Sql dba

1097

---

Can we insert in view in sql?

1050

---

write an sql query to find names of employee start with 'a'? : Sql dba

1023

---

What does count (*) mean in sql?

1579

---

how is exception handling handled in mysql? : Sql dba

1075

---

What is constant in pl sql?

1012

---

How does postgresql compare to mysql?

1032

---