Answer Posted / rajesh chauhan

sql>select max(salary)from(select salary from employee where
salary not in(select max(salary)from employee))

How to load data with sql*loader?

1000

---

what are the security recommendations while using mysql? : Sql dba

1051

---

What if we write return in procedure?

1336

---

What are the types of views in sql?

1041

---

What are the types of queries in sql?

1016

---

What is composite data type in pl sql?

1034

---

give the syntax of grant and revoke commands? : Sql dba

1090

---

Can I create table without primary key?

940

---

How do I copy a table in sql?

931

---

How do you change a value in sql?

967

---

What is the difference between sum and count in sql?

938

---

What is the difference between rollback and rollback to statements?

1015

---

What are expressions?

954

---

What are % type and % rowtype?

983

---

Where is pl sql used?

905

---