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
- 12785 Views
- Fidelity, IBM, I also Faced
- E-Mail Answers
Answer Posted / ramesh
Select count(id), accnt_type from Account
group by accnt_type;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
State some properties of relational databases?
How insert into statements in sql?
What is the difference between function and procedure in pl/sql?
Explain character-manipulation functions?
What is a database event trigger?
What is pl sql block in dbms?
How do I order by ascending in sql?
Does mysql support pl sql?
What is bulk compiling in pl/sql.?
how to start mysql server? : Sql dba
What is a sql select statement?
What is right join in sql?
Write a query to display the current date in sql?
What are all different types of collation sensitivity?
What is cold data?
