select count(acnt_type),acnt_type from a group by acnt

i have a table with fields(id,name,accnt_type)and in account
type are FD,SAVING,RD. Write a query to get How many number
of People are in each type of Account?

Question Posted / malthesh sagar

6 Answers
13818 Views
Fidelity, IBM, I also Faced
E-Mail Answers

Answer Posted / malthesh sagar

select count(acnt_type),acnt_type from a
group by acnt_type;

Is This Answer Correct ?

10 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between drop and truncate commands?

1054

what is 'mysqlshow'? : Sql dba

1018

What is graph sql?

981

Compare sql & pl/sql

1126

Why do we need a foreign key?

1086

How can a function retun more than one value in oracle with proper example?

1071

Mention what is the use of function "module procedure" in pl/sql?

1045

Explain the working of foreign key?

1058

What is bulk compiling in pl/sql.?

1122

How does pl sql work?

957

what is the functionality of the function htmlentities? : Sql dba

947

What is a ddl command?

1080

what are ddl statements in mysql? : Sql dba

1188

What are analytic functions in sql?

1021

Is there a 64 bit version of ssms?

954