Answer Posted / mallikarjuna

select max(sal) from emp where sal<(select max(sal) from emp);

how to see the create table statement of an existing table? : Sql dba

1060

---

When is the explicit cursor used ?

1091

---

How does a covering index work?

1011

---

What are the different types of dbmss?

1058

---

What is attribute indicator in pl sql?

1068

---

How to know the last executed procedure?

1157

---

What is the difference between drop and truncate commands?

1113

---

How can you save or place your msg in a table?

1042

---

what is the difference between delete and truncate commands? : Sql dba

1119

---

what are set operators in sql? : Sql dba

1108

---

In what condition is it good to disable a trigger?

1073

---

Why coalesce is used in sql?

1069

---

Can we rollback after truncate?

1073

---

What are the types of queries in sql?

1129

---

How many unique keys can a table have?

1070

---