Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14023 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
How to return an array from java to pl/sql?
What are data types in pl sql?
How can you save or place your msg in a table?
How do you use a while loop in pl sql?
In a distributed database system, can we execute two queries simultaneously?
what is union, minus and interact commands? : Sql dba
what is a composite key ? : Sql dba
What is the execution plan in sql?
What is a sql profiler?
how to shut down the server with 'mysqladmin'? : Sql dba
Is vs as in pl sql?
How to get each name only once from an employee table?
Define SQL and state the differences between SQL and other conventional programming Languages?
What is sql in oracle?
What is the non-clustered index in sql?
