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 )

Does user triggers have entry for trigger with compilation errors?

1039

---

Why do we use sql constraints?

1175

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

975

---

What are the different datatypes available in PL/SQL?

1088

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1041

---

Explain ddl statements in pl/sql?

1013

---

What is union?

1174

---

Why having clause is used in sql?

983

---

How do you know if a relationship is 2nf?

947

---

What are types of joins?

967

---

What is the trigger in sql?

959

---

What are inner outer left and right joins in sql?

1016

---

what is primary key? : Sql dba

1033

---

How does postgresql compare to "nosql"?

1036

---

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

954

---