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 query syntax?

957

---

what is the difference between a web-garden and a web-farm? : Sql dba

1066

---

How do we use distinct statement? What is its use?

1016

---

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

1044

---

Why do we go for stored procedures?

1038

---

what are the disadvantages of mysql? : Sql dba

1132

---

What is the purpose of the partition table?

1036

---

What is sql engine in oracle?

974

---

What is the difference between a query and a report?

953

---

What is the use of non clustered index?

979

---

what is a database lock ? : Sql dba

1154

---

What is pl sql architecture?

947

---

what is the syntax for using sql_variant_property? : Transact sql

1026

---

What do you think about pl/sql?

1006

---

Why use triggers in sql?

936

---