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 the difference between blob and text? : Sql dba

961

---

What does closing a cursor do?

1244

---

what are rollup and cube in t-sql? : Transact sql

1047

---

define join and explain different type of joins? : Sql dba

898

---

What does t sql mean?

896

---

What is coalesce sql?

940

---

Does pl sql work in mysql?

919

---

What are the different types of dbmss?

963

---

How many types of literals are available in pl sql?

1045

---

What are the set operators in sql?

1028

---

how to use 'mysql' to run sql statements? : Sql dba

983

---

What is trigger in sql?

1027

---

What does the sign mean in sql?

918

---

Can you have a foreign key without a primary key?

900

---

What is the purpose of the partition table?

1002

---