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 )

How to place comments in pl/sql?

1139

---

What is %rowtype in pl sql?

974

---

What are the advantages of pl sql over sql?

1009

---

What is trigger with example?

1065

---

what happens if null values are involved in expressions? : Sql dba

1026

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1165

---

Why do we need view in sql?

966

---

Why is theta join required?

1122

---

How do I pipe the output of one isql to another?

989

---

What is update query?

959

---

Can instead of triggers be used to fire once for each statement on a view?

948

---

What are conditional predicates?

1031

---

What is sql catalog?

999

---

what is log shipping? : Sql dba

1092

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

983

---