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
13831 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 the difference between 'between' & 'and' operators in sql

996

What is varchar sql?

1131

what is single byte over head in oracle..?

2397

Name the operator which is used in the query for pattern matching?

940

Write a sql query to convert all character to uppercase after hypen.

1433

What is t-sql? : Transact sql

982

What is cold data?

950

How many types of sql are there?

984

what is the difference between delete and truncate commands? : Sql dba

1065

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1063

What is the use of sql trace?

950

What does dml mean?

982

explain primary keys and auto increment fields in mysql : sql dba

972

What is the difference between having and a where in sql?

1100

how many sql dml commands are supported by 'mysql'? : Sql dba

1115