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

How many types of tables are there?

933

---

What is a common use of group by in sql?

1030

---

Why is there a need for sqlcode and sqlerrm variables?

1030

---

Why do we use procedures in pl sql?

1010

---

What are the operators used in select statements?

1044

---

What are different types of sql commands?

1095

---

how to drop an existing index in mysql? : Sql dba

1053

---

Which table is left in left join?

992

---

what is the difference between blob and text? : Sql dba

1003

---

What is sql entity?

1077

---

What is the requirement of self-join?

1100

---

Can we change the table name in sql?

925

---

what does the t-sql command ident_current does? : Transact sql

965

---

What is the cause of mutating table error and how can we solve it?

1036

---

Can we create view in stored procedure?

944

---