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
- 14041 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 is sql and also describe types of sql statements?
What is a string data type in sql?
what is a foreign key ? : Sql dba
What is delete command in sql?
In a distributed database system, can we execute two queries simultaneously?
What are the different ddl commands in sql?
what is a field in a database ? : Sql dba
explain the difference between bool, tinyint and bit. : Sql dba
What do you understand by case manipulation functions?
Is primary key clustered index?
Why query optimization is needed?
What is the sql query to display the current date?
What is the maximum number of rows in sql table?
What does pl sql stand for?
How many types of keys are there in sql?
