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

Explain autonomous transaction.

1220

is mysql query is case sensitive? : Sql dba

1163

How to write html code in pl sql?

1159

Explain alias in sql?

1094

What is t sql used for?

1059

What do you mean by dbms? What are its different types?

1062

What are sql constraints?

1226

What is a mutating table and a constraining table?

1178

What are the benefits of triggers?

1217

What is an alias command?

1114

What are the differences between in and exists clause?

1164

Is sql port 1433 encrypted?

1086

Is ms sql traffic encrypted?

961

give the syntax of grant and revoke commands? : Sql dba

1216

what happens if null values are involved in expressions? : Sql dba

1092