Answer Posted / vasanth

HI,

Include equal to (=) in that query:

select *
from temp_search
minus (select *
from temp_search
where rownum <= (select count(*) - n from
temp_search))

Another example:

select xx.*
from (select rownum rr, a.* from temp_search a) xx
where xx.rr > (select count(1) - n from temp_search)

*- n : no of last tranactions

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1212

---

what are the disadvantages of mysql? : Sql dba

1073

---

What is the purpose of the partition table?

999

---

How to run sql statements with oracle sql developer?

997

---

Can instead of triggers be used to fire once for each statement on a view?

894

---

What is the difference between function, procedure and package in pl/sql?

1129

---

What are different sql data types?

951

---

how to convert numeric values to character strings? : Sql dba

1034

---

Explain how exception handling is done in advance pl/sql?

954

---

what is recursive stored procedure? : Sql dba

929

---

What are variables in pl sql?

1090

---

What is the difference between view and stored procedure?

908

---

what is the difference between sql and t-sql? : Transact sql

1040

---

Is it important to partition hard disk?

964

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

1313

---