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
13621 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 many developers work on postgresql?

915

What is the sql case statement?

951

Why do we use view in sql?

909

What is duration in sql profiler trace?

1021

What are packages in pl sql and also explain its advantages?

959

What is compilation error in pl sql?

920

What is the maximum number of columns in sql table?

1088

How can you save or place your msg in a table?

953

Is it possible to create the following trigger: before or after update trigger for each row?

1237

What is dbo in sql?

919

Can a key be both primary and foreign?

944

What is the difference between a primary key and a clustered index?

929

what is query cache in mysql? : Sql dba

991

How do temporal tables work?

907

How does a self join work?

990