Answer / hussain

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

Answer / v.siva ramudu

SELECT CNUM,FNAME, DEPTNO
FROM COMPANY
WHERE CNUM <= 10;

what is query cache in mysql? : Sql dba

0 Answers  

---

what is cross join? : Sql dba

0 Answers  

---

What is not in sql?

0 Answers  

---

What is t sql used for?

0 Answers  

---

how to convert character strings to numeric values? : Sql dba

0 Answers  

---

What is the difference between between and in condition operators?

0 Answers  

---

What are triggers, and when would you use them?

3 Answers  

---

what tools available for managing mysql server? : Sql dba

0 Answers  

---

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

---

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

3 Answers   TCS,

---

What is a 'instead of trigger'?

3 Answers   Eenadu, TCS,

---

What are the different datatypes available in PL/SQL?

0 Answers  

---