Answer / kavitha nedigunta

select city,
count(decode(lower(gender),'male','female',null)) male,
count(decode(lower(gender),'female','male',null)) female
from gen
group by city;

Answer / sp

SELECT
city, COUNT(
CASE gender
WHEN 'male' THEN 'male'
END ) AS 'male' ,COUNT(
CASE gender
WHEN 'female' THEN 'female'
END ) AS 'female'
FROM info AS u group by city;

Is sql a case sensitive language?

0 Answers  

---

What does cursor do in sql?

0 Answers  

---

What is tuple in sql?

0 Answers  

---

how are mysql timestamps seen to a user? : Sql dba

0 Answers  

---

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

0 Answers  

---

Which join is like inner join?

0 Answers  

---

Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)

6 Answers  

---

can we call a procedure from a function?

9 Answers   Mind Tree,

---

What are the two parts of a procedure ?

6 Answers   Hi Caliber IT,

---

What is a schema in sql?

1 Answers  

---

What is mutating sql table?

0 Answers  

---