Answer Posted / ashish jain

select Salary from
(
select salary,ROW_NUMBER() over (order by salary desc) as rownum from Emp group by salary) temp
where rownum=2

Note :It can be used to get any highest salary, just use where rownum=nth salary

What are different types of triggers?

1106

---

How do rank () and dense_rank () differ?

1042

---

What do you mean by field in sql?

1075

---

What is oracle and pl sql?

1116

---

What is row_number () in sql?

978

---

What is consistency?

1115

---

Explain the insert into statements in sql?

1003

---

What is scalar function in sql?

1038

---

what are the different tables present in mysql? : Sql dba

980

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1025

---

How do I get sql certification?

964

---

What is sql performance tuning?

913

---

What is sql integrity?

1147

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1185

---

what is normalization? : Sql dba

1080

---