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
- 12793 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
What is partition by in sql?
what are the types of subquery? : Sql dba
what are the 'mysql' command line options? : Sql dba
How do temporal tables work?
How do I run a sql query in pgadmin 4?
Who developed sql?
Are dml statements autocommit?
differentiate between float and double. : Sql dba
What does cursor do in sql?
How do I count duplicates in sql?
What is duration in sql profiler trace?
What is the maximum number of triggers, you can apply on a single table?
How do sql databases work?
What is where clause in sql?
how do you know the version of your mysql server? : Sql dba
