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 are the types of operators available in sql?

0 Answers  

---

Explian rowid, rownum?

0 Answers  

---

What is the best sql course?

0 Answers  

---

What is gpt format?

0 Answers  

---

What is indexing oracle sql?

0 Answers  

---

What is rename in sql?

0 Answers  

---

In a table only one column how to update rows

5 Answers   Microsoft,

---

What is a primary key sql?

0 Answers  

---

How do I find duplicates in sql?

0 Answers  

---

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

---

How to fetch the rows by dynamicaly passing table name through cursor?

3 Answers  

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---