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
14028 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

When do we use triggers?

1145

what is top in tsql? : Transact sql

1171

What is cursor in pl sql with examples?

1089

How do you write a complex sql query?

1141

What is primary key sql?

1108

What are the built in functions of sql?

1092

What is prepared statement in sql?

1100

What is a dirty read sql?

1243

how many ways we can we find the current date using mysql? : Sql dba

1144

How exception is different from error?

1065

Is a view faster than a stored procedure?

1009

What are records give examples?

1050

What is having clause in sql?

1018

what is 'mysqladmin' in mysql? : Sql dba

1073

What is a schema? How is it useful in sql servers?

1174