Answer Posted / yaswanth

select salary from(select salary,rownum rk from(select salary from employees order by salary desc)) ehere rk=2;

What are different types of keys?

1096

---

How to rename a table?

1010

---

What is pl/sql table? Why is it used?

1030

---

Can there be 2 primary keys in a table?

993

---

What is a pdo connection?

1025

---

What are sql commands?

1008

---

What is substitution variable in pl sql?

1040

---

What is an oracle stored procedure?

1048

---

Explain the working of primary key?

1087

---

how many tables will create when we create table, what are they? : Sql dba

1067

---

What is audit logout in sql profiler?

1017

---

What are database links used for?

1040

---

how to use myisamchk to check or repair myisam tables? : Sql dba

966

---

What is java sql package?

1088

---

Can 2 queries be executed simultaneously in a distributed database system?

1140

---