Answer Posted / priyanga.g

1) Select MAX(salary) from Programmer where salary not
in(select top 2 salary from Programmer order by salary desc)



2) Select max(salary) from programmer where salary<
(select MAX(salary) from Programmer where salary<(select
MAX(salary) from Programmer))


3) Select MAX(salary) from Programmer e where 2=(select
COUNT(*) from programmer b where b.salary>e.salary )

What is a temp table?

960

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

930

---

Write a query to display the current date in sql?

979

---

What is the usage of sql functions?

1096

---

What is scope of pl sql developer in future?

969

---

How do I view a table in sql?

967

---

How to display the current date in sql?

1024

---

Why do we need view in sql?

948

---

what are the types of subquery? : Sql dba

1064

---

how to convert dates to character strings? : Sql dba

1103

---

What is orm in sql?

1006

---

What is the difference between instead of trigger and after trigger?

966

---

What is exception? What are the types of exceptions?

1044

---

What does select * from mean in sql?

3100

---

Who is the owner of mysql database?

1014

---