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
- 12792 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
What are the types of keys?
what is the difference between truncate and delete statement? : Transact sql
how can we know the count/number of elements of an array? : Sql dba
State few characteristics of pl/sql?
What are string functions in sql?
How do I save a stored procedure?
Can a composite key be null?
How to create a menu in sqlplus or pl/sql?
Is delete faster than truncate?
Is and as keyword in pl sql?
Can we have two clustered index on a table?
what is meant by urlencode and urldocode? : Sql dba
Can we create foreign key without primary key?
how can you see all indexes defined for a table? : Sql dba
What is an invalid partition table?
