Answer Posted / ramesh.p

Select salary
From ( Select salary from emp order by salary desc)
Where rownum =2;

Are stored procedures faster than dynamic sql?

1105

---

How do I view tables in sql developer?

1009

---

What is primary key secondary key alternate key candidate key?

1087

---

What are the different types of database management systems?

1036

---

Is it possible to create startup or shutdown trigger for on-schema?

1092

---

what are all the common sql function? : Sql dba

1106

---

Explain the select statement in sql?

1184

---

What is sql and explain its components?

1119

---

Does mysql_real_escape_string prevent sql injection?

995

---

How do I pipe the output of one isql to another?

1058

---

Is pl sql better than sql?

1088

---

How do we use distinct statement? What is its use?

1075

---

Explain mutating table error.

1262

---

what are the difference between clustered and a non-clustered index? : Sql dba

1086

---

define sql insert statement ? : Sql dba

1080

---