Select count(*), accnt_type from Account where accnt

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 / shivainduja

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

Answer Posted / shivainduja

Select count(*), accnt_type from Account where accnt_type in
(FD,SAVING,RD) group by accnt_type;

Is This Answer Correct ?

30 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why we use triggers in mysql?

936

What do you mean by field in sql?

1034

How do you determine the current isolation level? : Transact sql

1068

What is the difference between microsoft sql and mysql?

920

How can I tell if sql is running?

992

What is a schema sql?

1053

What is the difference between nested table and varray?

942

How much does sqlite cost?

985

define sql delete statement ? : Sql dba

970

What are the different ddl commands in sql?

1065

how to run 'mysql' commands from a batch file? : Sql dba

1061

How show all rows in sql?

974

What is sql character function?

994

explain mysql aggregate functions. : Sql dba

940

What are all the common sql functions?

969