Answer Posted / sudhakar tripathi

select Max(salary) "2nd_Heigh_sal" from employees where
(salary < select Max(salary) from employees);

explain what is mysql? : Sql dba

1133

---

What is the difference between drop and truncate commands?

1113

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1087

---

What is error ora-01000: maximum open cursors exceeded

1214

---

What is the main reason behind using an index?

1060

---

What is dynamic query?

1036

---

What is a unique key and primary key and foreign key?

1023

---

what are the performance and scalability characteristics of mysql? : Sql dba

1035

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

1018

---

What is clustered and nonclustered index in sql?

987

---

What are the types of index in sql?

1124

---

How many types of triggers exist in pl/sql?

1137

---

What is row_number () in sql?

1025

---

What are synonyms in sql?

1027

---

What is set transaction?

1090

---