Answer Posted / subhani

some of above have used corelated subqueries but it is not
recommonded to use.
best way is
select * from emp where rownum<=5
minus
select * from emp where rownum<5;

is it possible to pass an object or table to a procedure as an argument?

689

---

What is an inner join sql?

629

---

What is anonymous block in sql?

725

---

What is the difference between the implicit and explicit cursors?

637

---

How many sectors are in a partition?

664

---

---

What are sql queries used for?

637

---

List out the acid properties and explain?

645

---

What is trigger price?

640

---

What is string join?

657

---

Is sql a scripting language?

608

---

How do you take the union of two tables in sql?

605

---

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

700

---

Why indexing is needed?

612

---

What is optimistic concurrency control? : Transact sql

632

---

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

623

---