Answer Posted / surendra kumar dattatrey

Select * from Emp where Salary =
(Select max(Salary) from Emp where Salary <
(Select max(Salary) from Emp where Salary <
(Select max(Salary) from Emp where Salary <.....N))))

How to avoid duplicate records in a query?

1008

---

what are the join types in tsql? : Transact sql

1064

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1769

---

What is normalisation in sql?

1057

---

What is on delete restrict?

1000

---

How to return multiple rows from the stored procedure?

970

---

What is union and union all keyword in sql and what are their differences?

1108

---

What does partition by mean in sql?

963

---

How to find 3rd highest salary of an employee from the employee table in sql?

1083

---

What are the advantages of pl sql over sql?

1025

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1077

---

what is a constraint? Tell me about its various levels. : Sql dba

988

---

Can we rollback truncate?

998

---

What are the basic techniques of indexing?

1063

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1638

---