Answer Posted / jprakash025

select * from emp
minus
select * from emp
where
rownum<=(select count(*)-10 from emp);

or



SQL> select * from
2 (select rownum a, emp.* from emp)
3 where
4 a>(select max(rownum)-10 from emp);

What is the most common sql injection tool?

1044

---

What is example of database?

1061

---

What sql database should I use?

1146

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2491

---

How is a process of pl/sql compiled?

1162

---

What is a heap in sql?

1075

---

What is difference between stored procedure and trigger?

1171

---

what are the types of subquery? : Sql dba

1107

---

What is rename in sql?

978

---

how can you see all indexes defined for a table? : Sql dba

1000

---

What is snowflake sql?

1079

---

Can I call a procedure inside a function?

1016

---

Which is faster joins or subqueries?

991

---

what is bcp? When does it used? : Sql dba

991

---

what is rollback? : Sql dba

1115

---