Answer Posted / yaswanth

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

Is vs as in pl sql?

494

---

What is normalisation and its types?

550

---

How do I create a memory optimized filegroup?

529

---

What is the use of <> sql?

555

---

What is rtm in testing?

576

---

---

What is the difference between having and a where in sql?

572

---

What is inner join in sql?

586

---

What are synonyms in sql?

534

---

What is sqlservr exe?

480

---

What is cursor in pl sql?

578

---

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

594

---

Where is pl sql used?

521

---

What are the basic techniques of indexing?

577

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

556

---

What is a temporal data type?

597

---