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 does pl sql stand for?

1097

---

Is sql a scripting language?

975

---

Are views faster than queries?

977

---

How many subqueries can be nested in a statement?

972

---

Are subqueries better than joins?

958

---

what is the functionality of the function htmlentities? : Sql dba

930

---

What is the maximum number of triggers, you can apply on a single table?

983

---

What is varray in pl sql?

1059

---

how can we find the number of rows in a table using mysql? : Sql dba

1069

---

What is left join example?

934

---

Explain what is sql*plus?

1125

---

What does the file extension accdb stand for?

959

---

Enlist the advantages of sql.

987

---

Differentiate between pl/sql and sql?

1132

---

how would you enter characters as hex numbers? : Sql dba

968

---