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
- 11953 Views
- Fidelity, IBM, I also Faced
- E-Mail Answers
Answer Posted / malthesh sagar
select count(acnt_type),acnt_type from a
group by acnt_type;
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
How to assign sql query results to pl sql variables?
How to know the last executed procedure?
Is sql microsoft?
What is trigger price?
Does mysql support pl sql?
What are data types in pl sql?
What does over partition by mean in sql?
What is the difference between a database and a relational database?
What does the hierarchical profiler does?
Explain 3 basic parts of a trigger.
how are mysql timestamps seen to a user? : Sql dba
explain the options of myisamchk to improve the performance of a table. : Sql dba
Which kind of parameters cannot have a default value in pl sql?
what is timestamp in mysql? : Sql dba
Can a table have no primary key?
