Answer Posted / sunil bisht

Hi Shajin
above answere is perfectly correct.
but i have one more method..


select * from emp where rownum<6 minus select * from emp
where rownum<=4;

What is the usage of when clause in trigger?

571

---

Is sql a oracle?

527

---

What is flag in sql?

546

---

what is a unique key ? : Sql dba

547

---

Which version of sql do I have?

566

---

---

How to return an array from java to pl/sql?

594

---

explain mysql aggregate functions. : Sql dba

550

---

How do I install microsoft sql?

531

---

What is rename command in sql?

468

---

How do you copy a table in sql?

563

---

Can we create clustered index without primary key?

525

---

Are subqueries better than joins?

536

---

What is mutating error?

511

---

Is sql pronounced sequel or sql?

747

---

What is a recursive join sql?

597

---