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

Is not equal in sql?

1015

How to start the command-line sql*plus?

1058

When to use inner join and left join?

961

Why do we use sqlite?

982

How to prepare for oracle pl sql certification?

1069

How do I run a program in pl sql?

1007

How are functions and procedures called in PL/SQL?

1235

What is data type in sql?

967

how to shut down the server with 'mysqladmin'? : Sql dba

1014

What are the types of queries in sql?

1086

Will truncate release space?

956

What is difference between primary and secondary key?

1029

What are the properties of a transaction?

1130

How do I clear the screen in sql plus?

1047

What is the difference between the conventional and direct path loader? : aql loader

1157