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

Is join same as left join?

1041

What is difference between sql and oracle?

1131

What is where clause in sql?

1041

What is the clause we need to add in function body to return variable?

1012

how would you enter characters as hex numbers? : Sql dba

985

What are synonyms in sql?

973

What is spool?

1055

What is informix sql?

980

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

963

How can I speed up sql query?

963

Is there a 64 bit version of ssms?

961

What does select top 1 do in sql?

1098

Explain autonomous transaction.

1157

What is auto increment in sql?

1123

Which command is used to delete a trigger?

1333