Select count(accnt_type), 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 / jithu

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

Answer Posted / jithu

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

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to select random rows from a table?

1071

Does oracle roll back the transaction on an error?

1008

What is string data type in sql?

1136

define sql insert statement ? : Sql dba

1019

Why we use join in sql?

960

What does a pl/sql package consist of?

971

How many unique keys can a table have?

1010

What is the starting oracle error number?

1051

Is grant a ddl statement?

894

Why is a primary key important?

1036

Is sql difficult?

1148

Can you join views in sql?

951

What is sql*plus?

1072

Is pl sql useful?

985

How do you rank data in sql?

997