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  

---

What is the most important ddl statements in sql are?

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

What is the trigger in sql?

0 Answers  

---

what is 'force view'?

3 Answers   Cap Gemini, SPIC,

---

What company owns postgresql?

0 Answers  

---

How many triggers can be applied on a table?

0 Answers  

---

How do you update a value in sql?

0 Answers  

---

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  

---

What are sql procedures?

0 Answers  

---

how to enter binary numbers in sql statements? : Sql dba

0 Answers  

---

Write the command to remove all players named sachin from the players table.

0 Answers  

---