Answer Posted / yaswanth

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

How does sql store data?

489

---

How to display Row Number with Records in Oracle SQL Plus?

594

---

What is left join example?

504

---

What is data control language?

532

---

How to assign sql query results to pl sql variables?

515

---

---

How do I view a sql trace file?

570

---

Can a varchar be a primary key?

540

---

What is an exception in PL/SQL? What are the two types of exceptions?

633

---

Is sql easier than java?

530

---

Why do we use joins in sql?

504

---

How run sql*plus commands that are stored in a local file?

526

---

Define overloaded procedure?

626

---

What is data profiling in sql?

521

---

How many sql statements are used? Define them.

580

---

What is latest version of sql?

530

---