Can a table contain multiple primary key’s?

0 Answers  

---

Which software is used for pl sql programming?

0 Answers  

---

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

---

select 10 from dual; y its showing all the rows with 10?

1 Answers  

---

What are the types of views in sql?

0 Answers  

---

Explain character-manipulation functions?

0 Answers  

---

Can we call dml statement in function?

0 Answers  

---

What is pseudo column ?

6 Answers   ABB,

---

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

---

What is pls_integer in pl sql?

0 Answers  

---

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  

---

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

1 Answers   CTS,

---