How to divide query output into groups in oracle?

0 Answers  

---

Which are the five query types available in oracle?

0 Answers  

---

find out the third highest salary?

92 Answers   CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6

2 Answers   TCS,

---

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  

---

What is the usage of analyze command in oracle?

0 Answers  

---

What are the trigger associated with image items ?

1 Answers   Oracle,

---

What are advantages of dateset in datastage?

0 Answers   iGate,

---

How do I escape a reserved word in oracle?

0 Answers  

---

How to use "while" statements in oracle?

0 Answers  

---

How to create DSN..Explain?

2 Answers   Accenture, BeBo Technologies, Infosys,

---

We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?

3 Answers  

---