I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.

3 Answers   TCS,

---

How to write a left outer join with the where clause in oracle?

0 Answers  

---

How to increment dates by 1 in oracle?

0 Answers  

---

Difference between cartesian join and cross join?

0 Answers  

---

What are various constraints used in SQL?

1 Answers   Polaris,

---

---

What is the maximum limit on the number of columns in a table?

0 Answers  

---

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

1 Answers  

---

Which of the following is not a database object TABLESPACE TABLE INDEX NONE

1 Answers  

---

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,

---

which statement is running fastly ie insert or delete?

13 Answers   Oracle,

---

What is an oracle user role?

0 Answers  

---

Is primary key indexed by default in oracle?

0 Answers  

---