Answer Posted / rameshwari

select ename,esal from
(select ename,esal from hsal
order by esal desc)
where rownum <=2;

Explain the difference between rename and alias?

554

---

Explain polymorphism in pl/sql.

649

---

What is sql and how does it work?

557

---

Are sql connections encrypted?

571

---

What is nested table in pl sql?

561

---

---

How can use stored procedures in sql?

595

---

what is data manipulation language? : Sql dba

538

---

what are date and time intervals? : Sql dba

571

---

How do I tune a sql query?

518

---

How do I turn a list into a table?

524

---

Is sql developer case sensitive?

532

---

Is primary key an index?

545

---

What is normalisation in sql?

557

---

Explain the working of foreign key?

557

---

Which one is faster ienumerable or iqueryable?

495

---