Answer Posted / shiva kumar

select max(salary) from table01
where salary <(select max salary from table01)

in mainframe env

What is autocommit sql?

540

---

Name the different types of indexes in sql and define them.

570

---

What is dense_rank in sql?

544

---

Define select, insert, create, delete, update, drop keywords

600

---

What is data type in sql?

556

---

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

554

---

What is an implicit commit?

560

---

What will you get by the cursor attribute sql%found?

539

---

What is sql integrity?

585

---

What is difference between db2 and sql?

533

---

What is loop in pl sql?

576

---

How to place comments in pl/sql?

606

---

What are the types of records?

537

---

What are views in sql?

547

---

Is primary key is clustered index?

531

---