how to enter characters as hex numbers? : Sql dba

0 Answers  

---

How many types of indexes are there in sql?

0 Answers  

---

Is primary key an index?

0 Answers  

---

what is an extent ? : Sql dba

0 Answers  

---

What is rowtype?

0 Answers  

---

---

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

---

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

2 Answers   CTS,

---

what is oracle sql,pl/sql with interfaces

2 Answers   TCS,

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

Wat is SGA ?

3 Answers   ABB,

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

0 Answers   Microsoft,

---

What is a pragma statement?

0 Answers  

---