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?
- 6 Answers
- 12846 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
What are the basic techniques of indexing?
What is #table in sql?
What are the packages in pl sql?
Whis is not false in primary key?
What is trigger in flip flop?
when is the use of update_statistics command? : Sql dba
What is sql keyword?
What are the types of variable use in pl sql?
What is the use of desc in sql?
what is recursive stored procedure? : Sql dba
How to disable a trigger name update_salary?
what is subquery? : Sql dba
What are different types of indexes?
what are the advantages of sql ? : Sql dba
What is composite primary key in sql?
