Answer Posted / shivdas suryawanshi

select salary from emp where salary=(select max(salary)
from emp where salary < (selct max(salary) from emp));

What is database migration?

963

---

What is rownum in sql?

1043

---

what is a database transaction? : Sql dba

1172

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1148

---

Do ddl statements need commit?

965

---

What plvcmt and plvrb does in pl/sql?

1319

---

Is sql sequential or random?

1029

---

Can we call dml statement in function?

1051

---

How do you update f as m and m as f from the below table testtable?

1852

---

What is delimiter in pl sql?

1062

---

What is execution plan in sql?

1041

---

Can we use joins in subquery?

1158

---

What are the parts of a sql statement?

1086

---

What is embedded sql in db2?

1013

---

What is string join?

974

---