Answer Posted / shivdas suryawanshi

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

How to prepare for oracle pl sql certification?

1012

---

what is a field in a database ? : Sql dba

991

---

What is the maximum number of columns in sql table?

1089

---

What is audit logout in sql profiler?

979

---

What is primary key and unique key?

1053

---

What are the advantages of normalization?

1040

---

What is sequence in sql?

945

---

how to create a table index in mysql? : Sql dba

987

---

How many sql databases can you have on one server?

1018

---

What are aggregate and scalar functions?

978

---

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1076

---

What is the need of a partition key?

942

---

Is mariadb a nosql database?

1007

---

what are the differences between require and include, include_once and require_once? : Sql dba

972

---

What is the purpose of primary key?

968

---