Answer Posted / sreeharibabu

SELECT id
FROM (select salary2.*, rownum rnum from
(select * from test ORDER BY id DESC) salary2
where rownum <=4)
WHERE rnum >= 4;

What is pl sql and why it is used for?

565

---

What is %s in sql?

560

---

What are hotfixes and patches?

521

---

what are the differences between char and varchar? : Sql dba

523

---

What is the clause we need to add in function body to return variable?

538

---

---

Mention what is the plv (pl/vision) package offers?

635

---

What is auto increment feature in sql?

616

---

Which sql statement is used to delete data from a database?

461

---

What are the most important characteristics of pl/sql?

571

---

What is varchar used for?

527

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

496

---

What type of join is sql join?

526

---

what are the different type of normalization? : Sql dba

550

---

What is synonyms?

570

---

How global cursor can be declare with dynamic trigger ?

1745

---