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

What are data types in pl sql?

1078

---

what is the difference between inner and outer join? Explain with example. : Sql dba

974

---

Can we debug stored procedure?

959

---

Explain polymorphism in pl/sql.

1059

---

List the different type of joins?

1004

---

What is the difference between left and left outer join?

895

---

How do I add a database to sql?

1064

---

Why partition by is used in sql?

971

---

What is indexing in sql and its types?

1008

---

What does <> sql mean?

989

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1003

---

Do ddl statements need commit?

925

---

What is auto increment feature in sql?

1069

---

How to load data with sql*loader?

1001

---

Which is faster subquery or join?

1148

---