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

what are the features and advantages of object-oriented programming? : Sql dba

1005

What is a table?

1008

Is it possible to read/write files to-and-from PL/SQL?

1100

Explain how to use transactions efficiently : transact sql

973

What is the usage of distinct keyword?

1062

What is benefit of creating memory optimized table?

970

What is the sql case statement?

1000

How can a pl sql block be executed?

944

Why sql query is slow?

988

What is sql architecture?

1045

How do you delete a table?

1072

What information is needed to connect sql*plus an oracle server?

1026

what is the difference between char and varchar data types? : Sql dba

1098

Does oracle use sql?

926

What is nested table in pl sql?

1069