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;

What is the meaning of disabling a trigger?

1183

---

Is pl sql a scripting language?

1036

---

What is serial sql?

982

---

Is sql low level language?

1024

---

What are character functions in sql?

943

---

What is cte?

986

---

What is string join?

981

---

Which sorts rows in sql?

1025

---

What is the command used to fetch the first 5 characters of a string?

1212

---

What do you mean by dbms? What are its different types?

1021

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1018

---

Difference between global and parameter variables?

1973

---

how to run 'mysql' commands from a batch file? : Sql dba

1124

---

what are aggregate and scalar functions? : Sql dba

1060

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1010

---