Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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?

Question Posted / tina

Answers were Sorted based on User's Feedback



Question: Below is the table city gender name delhi male ..

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;

Is This Answer Correct ?    8 Yes 2 No

Question: Below is the table city gender name delhi male ..

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 This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 Answers  

Fetch an entire row from the employees table for a specific employee ID:

2 Answers  

How do I view tables in mysql?

0 Answers  

I want to know last five transactions or records from emp table, from now?

11 Answers   Wells Fargo,

What are the different types of joins in sql?

3 Answers  

What is informix sql?

0 Answers  

How to run pl sql program in mysql?

0 Answers  

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

How can you fetch common records from two tables?

0 Answers  

what are the properties and different types of sub-queries? : Sql dba

0 Answers  

How is a PL/SQL code compiled?

0 Answers  

What is having clause in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories