Answer Posted / shiva kumar

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

in mainframe env

What is index example?

545

---

What do you mean by dbms? What are its different types?

549

---

How many clustered indexes can you have?

525

---

What is the basic structure of an sql?

562

---

what is an index? : Sql dba

513

---

---

What does the acronym acid stand for in database management?

529

---

What do you mean by rowid?

529

---

Can you sum a count in sql?

545

---

Define union, minus, union all, intersect ?

546

---

Why is stored procedure faster than query?

482

---

what is cursor. write example of it. What are the attributes of cursor.

736

---

Can we rollback after truncate?

557

---

What is t sql used for?

544

---

what is data manipulation language? : Sql dba

520

---

define sql update statement ? : Sql dba

556

---