Select count(id), accnt_type from Account group by 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 / ramesh

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

Answer Posted / ramesh

Select count(id), accnt_type from Account
group by accnt_type;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is trigger in pl sql?

990

Can a foreign key be a duplicate?

905

Why we use join in sql?

960

Can I create table without primary key?

994

What is cascade in sql?

961

Is like operator in sql case sensitive?

1018

How do you know if a relationship is 2nf?

940

What is posting?

1032

What does subquery mean in sql?

1046

What are local and global Indexes and where they are useful.

1437

Is sqlite good enough for production?

990

what is blob? : Sql dba

1143

Why do we use partitions in sql?

1041

How many unique keys can a table have?

1010

what is a constraint? Tell me about its various levels. : Sql dba

983